Forum Discussion

carlamos's avatar
carlamos
Copper Contributor
Jan 27, 2021

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

65762EXSturdy yet lightweight black polypropylene case for carrying and protecting artwork
65762EXFull width interior pocket and crossover elastic straps for keeping work safe
65762EXComfortable handles for carrying
65762EXAlso 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. 

65762EXSturdy yet lightweight black polypropylene case for carrying and protecting artworkFull width interior pocket and crossover elastic straps for keeping work safeComfortable handles for carryingAlso features full length nylon zip and feet on base

 

Is there a way to sort the sheet automatically?

 

Thanks in advance

Resources