Formula to transpose horizontal numeric data verti

Question

My input data in column A

1
2
3
4
5
6 
7 
8
9

If I want the above in Column B C D like

1 2 3
4 5 6
7 8 9

Answer 1

Use INDEX with some math:

=INDEX($A:$A,(ROW($A1)-1)*3+COLUMN(A$1))

Put in B1 copy over 3 columns and down 3 rows.

The *3 is the number of columns desired.