I need to copy 3 cells into one cell

Closed
GreenDragon - Oct 29, 2015 at 06:53 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 2, 2015 at 02:56 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Nov 2, 2015 at 02:56 PM
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