Transpose data (shopify product list related)

Hello! I'd consider myself a beginner to excel though I do understand how to write formulas and use most of the tools on excel.

I have a product list i am trying to organize which was exported from shopify. The problem is the images (primary, secondary, etc) populate the cells via a column with products varying from 1-5 images. example..


product 1 | image 1
-------------| image 2
-------------| image 3
product 2 | image 1
-------------| image 2


I need to organize the product images horizontally as I will be using the columns to populate a product list to upload to another platform.

product 1 | image 1 | image 2 | image 3
product 2 | image 1 | image 2


I am looking for a way to do this efficiently as i have about 18000 rows to go through... which would take way too long to simply copy / transpose.

Please let me know if this isn't clear.

Added Sample Attachment

1. Place the following formula in F2 then copy across as far as you need to cover at least the max number of images you expect for any product, then copy down to cover all 18,000 rows.
2. Formula:

   Please Login or Register  to view this content.

3. Copy cols F:K (or however many columns you decided in the previous step) then paste-values in order to replace the formulas with fixed values.
4. Sort the worksheet by "Title"
5. Select and delete all rows (which will now be contiguous) where "Title" is blank.

That's it!

Note - if this is a one-off exercise then this approach should work for you. If however this is something that you will need to do on a regular basis then a VBA solution may be better.

Originally Posted by GeoffW283

1. Place the following formula in F2 then copy across as far as you need to cover at least the max number of images you expect for any product, then copy down to cover all 18,000 rows.
2. Formula:

   Please Login or Register  to view this content.

3. Copy cols F:K (or however many columns you decided in the previous step) then paste-values in order to replace the formulas with fixed values.
4. Sort the worksheet by "Title"
5. Select and delete all rows (which will now be contiguous) where "Title" is blank.

That's it!

Note - if this is a one-off exercise then this approach should work for you. If however this is something that you will need to do on a regular basis then a VBA solution may be better.

Spot on! Ill be studying these functions thoroughly for further use and manipulation. Thank you!

Glad to help. Thanks for the feedback and reputation points