Transpose single column of data into three columns (...of seven)

I've tried googling "Transpose single column of data into multiple columns", and it gives many results, but not the unique one I need: columns of 7

1 8 15
2 9 16
3 10 17
4 11 18
5 12 19
6 13 20
7 14 21
22 29 36
23 30 37
24 31 38
25 32 39
26 33 40
27 34 41
28 35 42
43 50 57
44 51 58
45 52 59
46 53 60
47 53 61
48 55 62
49 56 63
64 71 78
65 72 79
66 73 80
67 74 81
68 75 82
69 76 83
70 77 84
...etc

The bold isn't needed, I just added that here for readability. I've found other formulas that can do this:

1 2 3
4 5 6
7 8 9
...etc

And I may have to end up using this (filed under Acceptable Compromise), but I'm hoping a formula exists to transpose the data to achieve the first result.

Try drag-copying this across, then down:

=INDEX($A:$A,INT((ROWS($A$1:A1)-1)/7)*14+ROWS($A$1:A1)+(COLUMNS($A$1:A1)-1)*7)

SOLVED! Much obliged!