Excel: Combine multiple rows into one based on column?


I've got multiple rows (with no overlapping data) and duplicates in a column, that looks like this:

-
A ASD
A REW
A ER
A EWQ
---
B FG
B SFDG
B ADSF
---
C ASD
C DFGA
C DF
I need to compress those down to single rows each based on the column with the duplicates so it looks like:
A ASD REW ER EWQ
B FG SFDG ADSF
C ASD DFGA DF
Ideas? Edit: Looking for a VBA solution btw.


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of November 11, 2014.


For more resources for Microsoft Excel