Swap rows and columns

[Raoul]

I'm working on a table and I'd like to swap the rows and
columns. E.g. Cell A2 gets Cell B1; A3 gets C1 etc.

Thanks for your help

 

[Bob Phillips]

Raoul,

Select the cells
Copy to clipboard
select the target start point
menu Edit>PasteSpecial
click the Transpose button
OK
tidy up the original data

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Gaurab Hazarika]

Use the transpose function to transpose. Its an array
function so you have to highlight the from area and
similar sized to area.

And pressing enter wont help, you have to press enter
holding control+shift key.