From Row to Column?

  • Thread starter Thread starter confused man
  • Start date Start date
C

confused man

Hello all, I have a large spreadsheet of data, unfortunately when I set it
up originally I put the data into rows (I.E. left to right) I'm trying to
correct that now, Is there any way I can highlight a row of data and move it
into a colum, in the same order it is in the rows?

Thank you,
Confused Man
 
Yep, select all the cells in your row, and copy then select the first cell
in your destination column and select "Paste Special" then transpose in the
Paste Special dialog and ... job done!!
 
Select your range and then
Edit|Copy
then select where it should be pasted and
Edit|paste special|and check the transpose box

(You can't overlap the From and To ranges while you're doing this)
 
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

Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
transferring data to new multiple spreadsheets 1
Mailing address block: sorting 1 row to columns 1
Moving a bunch of data 1
How to shade groups of rows in excel. 1
Unobtrusive Place To Put Report TItle and a List? 5
How to vary shading of groups of rows, based on change in value in aparticular column 9

Back
Top