Merge Rows by id

  • Thread starter Thread starter MWaters
  • Start date Start date
M

MWaters

I have a list as per below...
A B C D E F
123456 Mr Joe Smith 27 White St RED HILL
123456 Mr Joe Smith 21 Brown St RED HILL
123456 Mr Joe Smith 7 Red St RED HILL
567891 Ms Eve Smith 27 White St RED HILL
567891 Ms Eve Smith 27 Brown St RED HILL

I need it to be formatted like this, with address info for the same id
merged to the same row....

123456 Mr Joe Smith 27 White St RED HILL 21 Brown St RED
HILL
567891 Ms Eve Smith 27 White St RED HILL 27 Brown St RED
HILL

Thanks for your assistance,

MWaters.
 
Sorry, I wasn't clear.....
I don't need it in one cell, I just need it on one row still separated. I
have about 5000 addresses and ids are repeated up to 7 times.

a b c d e f
g h
123456 Mr Joe Smith 27 White St RED HILL 21 Brown St RED
HILL

Thanks,
 
Hi,

Are you using xl 2007? There is a utility on the Data Ribbon called Remove
Duplicates.
Its a light weight utility with basically no options, but you can select the
Column(s) from which you want to return a range with only unique values in
that column(s)

Let me know if not, there's lots of ways to get rid of duplicates.

Thanks,
Ariel
 
It's combining the contents of each row with the same id onto one line, but I
think I'll be able to slightly change the code from another question
(Jcraig713) to fit what I need.

Thanks,
 
Back
Top