Technowolf
Board Regular
- Joined
- Aug 28, 2014
- Messages
- 181
I've got multiple rows (with no overlapping data) and duplicates in a column, that looks like this:
<tbody>
</tbody>
I need to compress those down to single rows each based on the column with the duplicates so it looks like:
<tbody>
</tbody>
Ideas?
Edit: Looking for a VBA solution btw.
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.
Last edited: