Duplicates in separate rows, combined to single row.

[krich0524]

I have pages of information and want to be able to take any of the rows with the same "A" column information and combine them into a single row. I've attached a sample of what I'm looking for. The info on the left is how it exports in....I would like it to look like the info on the right. Basically if "A" has a duplicate, merge into single row.

Any help is appreciated,
Krich

[Melvinrobb]

Will this work?

[krich0524]

I tried it, and I see how it should work, but how do the account numbers get in column "I"?

[Melvinrobb]

I did not know you needed a formula for that.
My first suggestion would be to copy and paste the list, and then "remove duplicates".
If that won't work, look online for a formula to "extract unique values from a list". You should be able to find something that applies. this is one I found online and used in a file of my own:

Please Login or Register  to view this content.

I can't explain it to you. You can see how you might want to avoid a formula if it isn't necessary.

[krich0524]

Thanks for the help! I'll give it a try.

[Melvinrobb]

I went and made the necessary changes to make the formula work for you:

Please Login or Register  to view this content.

This is an Array formula! - Confirm with "CTRL-SHIFT-ENTER"