Skip to content

You are not logged in. Register orLog In

start:

Root / newfaq -- [Prev    -    Next ]

How can rows and columns of a spreadsheet be swapped?

You need to Copy or Cut the area you want to swap, then click on the top left cell of the area you want the swapped data to appear in, then use Edit|Paste Special with the Transpose option selected. Hope that helps Andy Lewis David N. Welton wrote: > [ Please CC replies to me. ] > > Hi, > > I have a table like this in the spreadsheet: > > 1 2 3 ... > A > B > C > . > . > . > > I would like to swap the rows and columns to make it > > A B C > 1 > 2 > 3 > > But haven't been successful in finding just how to do that. If > someone were to illuminate me, I would be grateful.

Root / newfaq -- [Prev    -    Next ]