Forum Discussion
carlamos
Jan 27, 2021Copper Contributor
product bullet data is in rows, need columns per product
I have a spreadsheet of data for products, column A is the product code, column B is bullet points.
As you can see the bullet points are listed in rows in column B, with the product code listed downwards also (example below
Code Bullet Point
| 65762EX | Sturdy yet lightweight black polypropylene case for carrying and protecting artwork |
| 65762EX | Full width interior pocket and crossover elastic straps for keeping work safe |
| 65762EX | Comfortable handles for carrying |
| 65762EX | Also features full length nylon zip and feet on base |
This style continues down for all 15000+ products, meaning 60000 rows.
I need it to be in the format below, so i have one row per product code and all the bullet points in columns.
I know transpose does this but with 15000+ products it would take a long time.
| 65762EX | Sturdy yet lightweight black polypropylene case for carrying and protecting artwork | Full width interior pocket and crossover elastic straps for keeping work safe | Comfortable handles for carrying | Also features full length nylon zip and feet on base |
Is there a way to sort the sheet automatically?
Thanks in advance
1 Reply
- SergeiBaklanDiamond Contributor
Power Query could work if you consider it as an option. Simple sample without cosmetic is in attached.