Switching rows and columns

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

Guest

I have been sent a sheet from which I want to extract data row by row, but
the rows are currently the columns and vice versa.

Is there a way to switch the orientation of the worksheet?
 
Look at Paste Special, Transpose

--
Kind regards,

Niek Otten

|I have been sent a sheet from which I want to extract data row by row, but
| the rows are currently the columns and vice versa.
|
| Is there a way to switch the orientation of the worksheet?
|
|
 

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

Column/Row Transfer Question 3
columns to rows flip 3
Reformat Row to Column 2
How to filter rows data based on background color of individual cells 1
Excel Help to copy information from one row at a time to another sheet 1
How can I move data from a row range to a column range 4
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row 2
Freeze multiple rows/columns in Excel 2007 11

Back
Top