Return multiple values into one cell as comma delimited.

jackbku

New Member
Joined
Mar 23, 2012
Messages
1
I have two sheets. First sheet (Data) contains data of all the SKUs that i carry in my store. Second sheet (Output) should organize by StyleID and output all Color and Default Image associated with StyleID. Multiple values of Color and Default Image need to be outputted as comma delimited.

So Sheet 1 will have following columns:
SKU, Color Attribute, StyleID, Default Image
10TR-SE1013-BLU-20 Blue 10TR-SE1013 10TR-SE1013-BLU.jpg
10TR-SE1013-WHT-20 White 10TR-SE1013 10TR-SE1013-WHT.jpg
10TR-SE1015-BLK-24 Black 10TR-SE1015 10TR-SE1015-BLK.jpg
10TR-SE1015-BLU-24 Blue 10TR-SE1013 10TR-SE1015-BLU.jpg
10TR-SE113-43-BLK Black 10TR-SE113 10TR-SE113-43-BLK.jpg
10TR-SE113-43-BLU Blue 10TR-SE113 10TR-SE113-43-BLU.jpg
10TR-SE113-54-GRY Gray 10TR-SE113 10TR-SE113-43-GRY.jpg
10TR-SE114-43-BLK Black 10TR-SE114 10TR-SE114-43-BLK.jpg
10TR-SE114-43-PUR Purple10TR-SE114 10TR-SE114-43-PUR.jpg
10TR-SE114-43-RED Red 10TR-SE114 10TR-SE114-43-RED.jpg
10TR-SE115-43-BLK Black 10TR-SE115 10TR-SE115-43-BLK.jpg
10TR-SE115-43-GRY Gray 10TR-SE115 10TR-SE115-43-GRY.jpg
10TR-SE115-43-WHT White 10TR-SE115 10TR-SE115-43-WHT.jpg



StyleID will have multiple colors and a corresponding image per color but will repeat image filename for same color but different sku sizes.

Sheet 2 will have following columns:
StyleID, Color Attribute, Default Image
Style Color Attribute Default Image
10TR-SE113 Black, White, Red 10TR-SE113-BLK-43.jpg, 10TR-SE113-WHT-43.jpg, 10TR-SE113-RED-43.jpg
10TR-SE114 Black, Blue 10TR-SE114-BLK-43.jpg, 10TR-SE114-BLU-43.jpg

I need to consolidate all unique colors and default images per StyleID and output results into one cell as comma delimited.

How can I include a formula in Sheet 2 for columns B and C to return multiple values as comma delimited?
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,122,158
Messages
5,594,585
Members
413,915
Latest member
namreh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top