Code to convert to columns, copy and transpose data

Here it is - my actual data has multiple rows - I already have the rows spaced with the correct number of gaps so that transposing the data will fit perfectly

So I just need code to fit inside the loop that I already have that creates the appropriate number of blank rows