Need to concatenate cells and remove duplicates

**jdcooper88** · 06-23-2014, 12:50 PM

Hello,

I currently have a spreadsheet that contains about 1700 lines of data related to ~400 different clients which I am looking to consolidate.

The data is currently in this format (a set like this repeated ~400 times with anywhere between 3 and 7 services):

Company ID # Company Name Service1

Company ID # Company Name Service2

Company ID # Company Name Service3

I would like to have the data in this format (one row per company with all of the services in the third column concatenated into a single cell, all while removing the duplicate rows.)

Company ID # Company Name Service1, Service2, Service3

Would anyone be able to help me create the code (or describe the process) necessary to do this?

Thank you for your time and consideration in this matter!

James Cooper

**Jakobshavn** · 06-23-2014, 01:13 PM

Has the data already been sorted?

**jdcooper88** · 06-23-2014, 01:23 PM

The data is currently sorted in alphabetical order by Company Name, however I could just as easily sort it by company ID # and work from there.