Concatenate Cells Containing Similar Values

[3winds]

Hi there! I'm trying to combine cell data in a column with like values into a comma separated string in a single cell. For example, a portion of my single column of data is a list of 12,000 sku's and looks like this:

sku
201461WHT0XS
201461WHT1SML
201461WHT4XL
201520BLK12
201520BLK14
201554BEIGE30
201554BEIGE32
201554BEIGE34
201554BEIGE36

What I want to do is, concatenate cells that have the same leading 6 numbers (base sku) into a single cell separated by comma or some other delimiter. So, output something like this:

sku
201461WHT0XS, 201461WHT1SML, 201461WHT4XL
201520BLK12, 201520BLK14
201554BEIGE30, 201554BEIGE32, 201554BEIGE34, 201554BEIGE36

Some products have only 2 sku's while others may have 100 variants. I need in this format in order to be able to upload products to our web store. I hope this makes sense. Any help would be hugely appreciated

[JieJenn]

]Try

Attachment 176860

Please Login or Register  to view this content.

[3winds]

Hi JieJenn! That is absolutely brilliant! Thank you soooo much