Thread: How do I combine rows, combining duplicates as well as concatenati
View Single Post
  #1   Report Post  
Donovan Panone
 
Posts: n/a
Default How do I combine rows, combining duplicates as well as concatenati
I'm trying to combine rows of data and I need a certain column to concatenate
only if it is in a group of rows that have duplicate information in another
column.

Example:

Before...

Column 1 Column 2
X A
X B
Y C
Y D

Desired After...

Column 1 Column 2
X AB
Y CD

This is for a spreadsheet with thousands of rows

Any suggestions?

Reply With QuoteReply With Quote