Swap rows and columns

  • Thread starter Thread starter Raoul
  • Start date Start date
R

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
 
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)
 
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.
 
Back
Top