- 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.
- 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.
- Sort the worksheet by "Title"
- 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.
Bookmarks