Combine Data From Multiple Rows If Data In Column A Is Identical

Hi there,

I have a spreadsheet with about 2,600 rows. Some rows will have the same data in Column A (a text field that describes the name of the item). Columns B to G contain data which will be identical for all rows with the same data in Column A. I then have Columns H to BV - there will be no more than 1 entry within that range for any row.

I'm trying to combine rows with identical values in Column A so that I have just 1 row per term in Column A but that row contains any and all values contained in Columns H to BV (in addition to the data in Columns B to G).

Some terms in Column A might only have 1 row associated with it. Others might have 2 or more. There is no set pattern.

I have attached two spreadsheets - one with an example of the original data (although with the number of columns reduced for simplicity) and another with what I'd like the desired output to be.

I appreciate the help. I've tried a couple other solutions but I can't seem to get them to work.

This should do

Please Login or Register  to view this content.

Thank you both! Both solutions worked perfectly. Very much appreciated.