Transferring vertical data into horizontal data

[EvansB2]

Hi,

I would like to transfer financial data that sits in a vertical table to a horizontal table without having to manually input the data. The same number of cells are in both. It is for presentation purposes.

Would appreciate any assistance.

Ben

 

[dave3009]

Highlight the vertical data, copy it

Go to a new clear area of the spreadsheet and right click>>paste special>>transpose>>OK

Job done

 

[EvansB2]

Thanks Dave.

Ben