Collumns and rows

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

Guest

Can someone please tell me how to convert a collumn of data into a row. ie
how to copy a collumn and paste it as a row. the reason i ask is because i
have two collumns of data which i am trying to create a scatter chart from
but for the life of me i cant do it-i hear that rows are best for creating
the chart-any thoughts?

Thanks very much everyone

Steve
 
smintey said:
Can someone please tell me how to convert a collumn of data into a row. ie
how to copy a collumn and paste it as a row. the reason i ask is because i
have two collumns of data which i am trying to create a scatter chart from
but for the life of me i cant do it-i hear that rows are best for creating
the chart-any thoughts?

Thanks very much everyone

Steve
Click to expand...

Copy-Paste Special-Transpose
 
Steve

If you have less than 256 rows in the column........

Copy>Paste Special>Transpose>OK>Esc.

Note: you cannot paste onto any part of existing data range.


Gord Dibben Excel MVP
 

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

Filling in cells (or not) based on the entry in a specific collumn 3
Switching from collumns to rows 3
extracting from 1 collumn mailing list 2
FORMULA 2
Multiple reports 2
Using zero's for the first number in excell collumns 5
Counting rows based on the contents of multiple cells 2
Counting sets of cells based on two parameters 4

Back
Top