change alignment

[lyealain]

hi may i know how to change the this

Jan Feb
Li 1 2
hor 100 101



to become this

Li hor
Jan 1 100
Feb 2 101

[sweep]

Hi,

Select the data, then

Edit > Copy

Edit > Psate Special > Transpose

[sathaha]

Hi,

Select the data, then

Edit > Copy

Edit > Psate Special > Transpose

Just the same
Hi,

Select the data, then

right click > Copy

and in the cell you want to transpose the data

right click> Paste Special > Transpose