I need to copy 3 cells into one cell

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am having a problem in excel I can't figure out. I have an example of what I am working with below. There are 3 columns A (SKU), B (Numeric Department Code) and C (Category). As you can see under column A there are 3 of the same SKU's each with different categories. I need the 3 different categories for each SKU to be on one line preferably, comma seperated with the just one SKU in a column next to it. Can someone help and let me know what I need to do to avoid sifting through 10,000 products manually? Thanks!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
There might be better way. one way would be a macro do that for you
1. copy column A to a new sheet
2. apply advanced filter and copy the unique values to B
3. delete column A
4. loop thru each cell and populate as you desire
0