I've got multiple rows (with no overlapping data) and duplicates in a column, that looks like this: A A A A XXX B B B XXX C C C I need to compress those down to single rows each based on the column with the duplicates so it looks like: A B C Ideas? Edit: Looking for a VBA solution btw. Last edited by Technowolf; Yesterday at 03:11 PM.
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:
This article includes the following tags: