Hi all.

I’ve been using the search and I have been unable to find anything related. If it exists please accept my apologies and point me out to it.

The thing is that I have to transpose a set of consecutive rows from a single column into a different sheet and row. However it needs it to be slightly different to the way transpose functionality works.
Normally you transpose a column into a row, so 1 goes into A, 2 into B, and so on.
However I need to transpose it in a non consecutive manner, so 1 goes into A, 2 goes into C, 3 goes into H, and so on. Is that possible? If so, how it is done?

And following with the same problem, is there a piece of code to incorporate in the same macro to find the first empty row and start transposing there?

Thanks very much for your help