Changing horizontal data to vertical data

[Stclements]

I have twelve cells of vertical data in a worksheet which I would like to put into a different worksheet in a horizontal fashion with all the correct data and formulae attached within the same excel workbook.
I have used paste options transpose but this didn't work.

 

[Stiuart_W]

What do you mean "it doesn't work"? and what EXACTLY are you doing?

I just tested copying 12 cells with header and a number in row 2 and the rest formulas of the ones above (Column A). I copied then paste special - transpose to C! and it worked fine