VBA code to copy n rows of data and paste into every second column

I'd be grateful for help with the following problem. I'm looking for code to copy 'n' rows of data, and paste special transpose into another sheet but for each value to have one column between them ie Cells A2, a3, a4....to be copied into a1, c1, e1 etc of sheet two. The number of rows will be unknown each time so the 'copy' code will incorporate 'xldown' and the paste is each column until all data is copied. Presumably a loop to work down the rows until a blank value is found and a copy function that offsets one column for each 'I' for 'I to n'

thanks. the code you suggested worked in the main but for some reason only copied the first 50 odd observations not the entire dataset. I was able to solve the problem using alternative code. thanks again for your input