a blog on living online and other tech stuff
To swap rows and columns
1. select the rows and columns you want to flip
2. copy the selection
3. go to Edit -> Paste Special -> Options and check “Transpose”
4. click on OK
By the way, this also works with Excel.