Excel 2007 : transform column to row

Hey Team

I have a column data A and would like to transform into row data
something like this format:

A B C
1-0.001
2[-0.03]
3
40.024
5[1.11]
6
70.032
8[1.04]
9


if it is possbile transfer to

A B C
1 -0.001 0.024 0.032
2 [-0.03] [1.11] [1.04]


thank you so much for the help!!!

Hi Wuruonan,

In cell B1 insert the formula:

=OFFSET($A$1,COLUMN(B1)*3-3,0)

In cell B2 insert the formula:

=OFFSET($A$2,COLUMN(B2)*3-3,0)

Fill both formulas to the right as far as needed to transpose all of the data. Remember, of course, that there are fewer columns than rows in Excel. Also, if you intend to delete the original data in column A, select rows 1 and 2 first and choose copy, then PasteSpecial -> Values. You can then delete everything below row 2.