Can I convert a column into a row?

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

Guest

Excel Question. I simply want to convert a column of figures [each in
different cells] into a row with a similar number of cells. Must be simple,
but can't seem to find how to do it. Thanks for any replies, guys!!
 
Select the cells in the column you want to paste in the row. copy (control
C). Select the same number of cells in a row, click Edit > Paste Special.
Select transpose. Click ok.

- Mangesh
 
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

Convert table to a single column 1
Convert rows to columns 5
How to covert rows to columns or columns to rows. 11
Splitting a cell into rows instead of columns 12
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
dividing a number into hours and minutes 1
I can only delete an entire row not a cell in excel 2013? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top