Return multiple values into one cell as comma delimited.

[jackbku]

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?