• Hot Topics

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 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:

  • Excel
  • Microsoft Excel

privacy policy