Excel: Concatenate Based on specific values

I am trying to concatenate a string of text separated by a comma based on specific values. you can see in the example I have attached that there is a column of parent skus (configurable) that match a column of child skus (simple). In the configurable row I need to concatenate all of the simple skus into the concatenate column separated by a comma. I need to do this for over 10,000 skus. https://wetransfer.com/downloads/11ac08dbbd4bf9bfbab67f565c59e1c220170709154430/69499eb2c2c42a88b5483ff52c7b303d20170709154430/2871d8

This question generated 7 answers. To proceed to the answers, click here.

This thread is current as of July 09, 2017.

For more resources for Microsoft Excel