View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dizzlews Dizzlews is offline
external usenet poster
 
Posts: 3
Default Compare Rows and delete duplicate records

HI,
I am very new to excel and trying to find a solution to filter my data.
My data lookes like the following

A B C D E F ...............
joe 12 14 16 90 80
joe 12 15 18 90 80
john 13 19 20 90 70
Sara 13 20 21 22 23
Sara 13 20 24 25 23

I want to combine the unique records of each user from all the rows into one
row so that it should look like below

A B C D E F G H I J
joe 12 14 16 90 80 15 18
john 13 19 20 90 70
Sara 13 20 21 22 23 24 25


I am sure most of you would know how to accomplsih it. Any quick help will
be greatly appreciated.

Dizzlews


--
Looking for some help