If column range contains specified column, concatenate matching values

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

Originally Posted by AliGW

Welcome to the forum!

Instead of an image, please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hello,

thanks for the warm welcome!

I've attached the workbook - I've used column B to demonstrate my requirements for the function/macro. Thanks for the heads up!

Bump, would really appriciate some help