Transpose according the image number

Hi Experts, I want to transpose column C into different columns, you can see image number when image end from 1 to any, lik in above example this image number end on 39 so all 39 links will be transpose int separate column, after this handle new handle is starting so all will be like this, is there any automation so I can do this quickly.


Thanks in advance

attached screenshot

any expert can help?

How about

Please Login or Register  to view this content.

Fluff Thanks for your help, it is working but also I want column A reduced cells

I have no idea what you mean by that.
Also there was no mention of Column A in your OP

now everything is ok.

Ok, thanks for the feedback