How to arrange number from row to column

[redza]

Hi All

I have many number in row A4. How to arrange the number from row A4 to column A only

Example

Now

(row A4) 2366.32 (row B4) 2468.51 (row C4) 2473.23 (row D4) 2570.72

Change to

(column A4) 2366.32
(column A5) 2468.51
(column A6) 2473.23
(column A7) 2570.72

[jeffreybrown]

Place in A5 and copy down...

=INDEX($A$4:$D$4,ROW(A2))

[redza]

Thanks jeffreybrown.

I want to know why need to place A2

=INDEX($A$4:$D$4,ROW(A2))

[jeffreybrown]

I want to know why need to place A2

Row(A2) returns the row number. As you drag the formula down, Row(A2), changes to Row(A3), Row(A4) and so on...

Basically it just keeps us from having to manually change the row_num as we drag down.

=INDEX($A$4:$D$4,ROW(A2)) >> =INDEX($A$4:$D$4,2)
=INDEX($A$4:$D$4,ROW(A3)) >> =INDEX($A$4:$D$4,3)
=INDEX($A$4:$D$4,ROW(A4)) >> =INDEX($A$4:$D$4,4)

Since you have the first number in A4 already, then B4 is the second number in the array to return and so on...

[jhren]

Too slow

Don't u just hate it when someone posts while ur typing up a reply...