Transposing rows to non-consecutive columns macroo

[fuchetj]

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

[StephenR]

1 to A
2 to C
3 to H

What's the logic?

[fuchetj]

1 to A
2 to C
3 to H

What's the logic?

None there, it was just an example.
The thing is that the data that I need to transpose comes from an on-line booking form, however, the sheet where I want it to transpose to needs extra columns in place, and those columns cannot be at the beginning or at the end of the row (which will solve most of my troubles), that's why I use the above as an example.

Example of the destination sheet, in red are the fields transposed from the form and where they should lay on the destination sheet.

Does it make more sense now?