I need to copy 3 cells into one cell
Closed
GreenDragon
-
Oct 29, 2015 at 06:53 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 2, 2015 at 02:56 PM
rizvisa1 Posts 4478 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!
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!
Related:
- I need to copy 3 cells into one cell
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Hitman 3 free download - Download - Action and adventure
- Granny 3 download pc - Download - Horror
- Fnia 3 - Download - Adult games
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 2, 2015 at 02:56 PM
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
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
