Row to Column

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

Guest

I have a row with 94 entries.

I would like this data converted to a column instead.

Is there an easy way to accomplish this?

Thank you.
 
Brian

Copy the row. Assume row 1

Select A2 and Paste Special>Transpose>OK>Esc.


Gord Dibben Excel MVP
 
Thank you Gord, worked like a charm.

Gord Dibben said:
Brian

Copy the row. Assume row 1

Select A2 and Paste Special>Transpose>OK>Esc.


Gord Dibben Excel MVP
Click to expand...
 
bass

OP stated "94 entries" so will have no problem, but thanks for the added
caveat.

Gord
 
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
Count the number of columns on row that are not empty within a ran 3
Reformat Row to Column 2
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
Getting Text data using the Data - Subtotal feature 1
Having Blank Cells, etc. ? 1
Conditional SUBTOTAL in XL210 Table 7
How do I sum a column based on 2 different column headers/criteria? 0

Back
Top