Convert column to row

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

Guest

I have numbers arranged in a column that I need to put in another application
by copy and paste. The other app only accepts data arranged in a row with a
maximum of 25 at a time. How do I convert the column into a row in excel so I
can copy and paste in a group of 25 instead of one at a time?

Thanks
Bob
 
You can copy and paste special > transpose. That should work.
Alternatively there is a TRANSPOSE command built in to excel.
 
Hi S Davis,
I tried it . It works but numbers briefly flash and then cells go blank!

Bob
 
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
using the =page! feature to transpose a row to column 0
How to find a value with multi-column, multi-record list 1
Rows to Columns 3
Converting Rows into Columns 3
convert columns to rows 6
Need suggestions on layout to report/pivot 3
actual row number 3

Back
Top