Transposing One Column to Multiple Rows

[Jose]

I have One Column of Monthly Hourly data, i.e., 24 hours each for 28, 30, 31
Days. I would like to transpose this data into Rows for Days and Columns for
Hours, i.e., 28, 30, 31 Rows by 24 Columns. Can someone please help me?

 

[Yong Heng]

A B C D E F G H
1 1 2 3 4 5 6 7
2 data
3 data
4 data
5 data
6 data

insert number 1 to 7 from cell B1 to cell H1

in cell B2 insert the formula (assuming 100 rows of data)
=INDEX(($A$2:$A$100),(ROW()-2)*7+B$1)

populate the formula to all cells in B:H by dragging your mouse.

Yong Heng