convert row to column

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I have information in a row on a spreadsheet. Is there a way to copy/cut and
paste that information into a column instead?

TIA
Ivor
 
Have you tried the Transpose yet? You copy the row, select the column you want to put the data in, paste special and check the transpose box
 
Highlight and Copy the Row;
then go to the column cell you wish the data to goto and click/select it,
then
do an Edit Paste-Special (check) Transpose<<Consider if you want to further
paste the de-formularized Value or not, also before ending>>
HTH
 
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

columns wrong data 2
Excel Help to copy information from one row at a time to another sheet 1
Excel Unable to insert cut rows into Excel online anymore? 0
How do I keep fill color constant when cut & copying text? 4
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Cut & Paste in Excel without erasing cell borders? 1
Copy paste data from a column to a row 0
Excel sheet with numbers as column & row headers - How? 3

Back
Top