deleting duplicates from columns

• pinky

  SSCommitted

  Points: 1997

  More actions

  March 30, 2006 at 9:30 am

  #93709

   

  Hi i need some help on deleting duplicates from columns.

  I have a table

  A	B	C
  1	2	9
  2	3	2
  1	5	4
  4	2	2
  1	2	5

  and i want the output some what like this

  A	B	C
  1		9
  2	3	2
  	5	4
  4	2
  		5

  If there are any duplicates in a column doesnt matter where ever it is mentioned but it should be mentioned only ones. Ex in column A i have got 3 duplicates (1). I want 1 to be displayed only once in that column no matter where ever it is and the remaining should be left blank. Can anyone please suggest me a way to proceed.   

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  March 31, 2006 at 8:28 pm

  #630260

  This thread has been cross-posted here!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**