flip spreadsheet data from row records to column record fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have my spreadsheet with rows as records and columns as fields

I want to change it so that the data is flipped so that the columns are
records and
the rows are fields.

What is the easiest way to do this?
 
Thank you!

Peo Sjoblom said:
Select the table, copy it, insert a new sheet and do edit>paste special and
select transpose

Regards,

Peo Sjoblom
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IS there a way to invert rows? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Flipping data - columns to rows and visa versa 2
Finding the next record in a column 2
columns to rows flip 3
Excel Help to copy information from one row at a time to another sheet 1
Flipping columns to rows 3
Excel Fit to page print options in Excel 1

Back
Top