rows to columns

  • Thread starter Thread starter wilson
  • Start date Start date
W

wilson

have created a table using 2000 but I now want the columns
to be rows and the rows to be columns.

Can this be done easily?
 
Hi wilson

depends on how many rows you've used ... if you've used under 256 then
you're okay

assuming this is the case select all the cells that you want
and copy them
go to another worksheet (best to do it here first & then you can put it
where you want afterwards)
and choose
edit / paste special
tick the transpose box and click OK

Cheers
JulieD
 
Hi
try the following
- copy your range (your rows if you don't have more than 256 rows)
- select your target column
- goto 'Edit - Paste Special' and choose 'Transpose'
 
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
Merging multiple columns into one column (dynamically) 1
Conditional SUBTOTAL in XL210 Table 7
counting blank cells within two columns 2
Formula Help 9
Having Blank Cells, etc. ? 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top