Hello,

I have a large Excel table, I need the data within to be sorted into a specific format.

Here is an image that will help with my explination

In A column is my Master SKU, this is unique to every product.

In the B column, this is what the result of the function would look like.

C and D column are irrelevant to this function.

E is the column which needs to be concatenated, up to 10 values could match 1 Master SKU, or as little as 1.


I don't have much experience with written formulas in Excel, so thanks for your time