Combine multiple rows into one based on column?

[Technowolf]

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
XXX
B	FG
B		SFDG
B			ADSF
XXX
C	ASD
C		DFGA
C			DF

<tbody>
</tbody>

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

<tbody>
</tbody>

Ideas?

Edit: Looking for a VBA solution btw.

 

[hiker95]

skywriter, DocAElstein,

Thanks for you input.


Technowolf,

Please follow the below instructions, and, someone else may try to help you.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.