Compare Rows and delete duplicate records

[Dizzlews]

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

 

[Little Researcher]

Hi Dizzlews,
How do you want to combine the data of each user if there are different
entries in the same column. You want to sum them or find the max or what?

 

[Dizzlews]

First of all, my apologies for my late response to your post. I got the email
from Microsoft but I was not able to go on to post the when I clicked on the
Link. I finally found my own post after two days.

to answer your question,

It does not matter where the entries are in the column, they will not follow
any sequence. So i am assuming if you have happen to have the Macro code,
each cell value needs to loop through the entire row.

Taking the example again for my data for Joe.
A B C D E F ...............
R1 joe 12 14 16 90 80
R2 joe 12 15 18 90 80

I believe this is how it should work.

1) Compare A2 with A1 If Not Equal then Do nothing
Else if equals
then B1, should be compared against all the values
in row 1 for Joe, If found a match then Do Nothing
Else if did not Found the Match then Add
to the row1 for joe, the sequence does not matter.......
Similarly B2, B3.........untill B100.
Once Row2 is completely comapred and added to row1, then it should deleted.


Thanks

 

[Dizzlews]

I am sorry I meant B2 in my example.... I have corrected it below again