I have data from F13 to F1299. I want to transpose and LINK every 11 cells
down column F to a new row on a new worksheet.

For example, every 2 cells down on a new row:
1
2
3
4
goes to
12
34

Is there any quick way to do this? Thanks.