how do i copy values that are in a column into a row elsewhere?

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

Guest

Hi, I know this is fairly basic, but I have a huge data set that is a bunch
of survey questions that have all been entered in. However, all the
information that I want in rows is currently in columns and vice versa.

I tried to use the TRANSPOSE function to fix this with no luck. i'm sure
there is an easy way to fix this, so if you know it, please tell me! thank
you.
 
One way is to copy and paste special with transpose as an option but that's
a 'manual" option.. What are the errors you are seeing with 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

Reformat Row to Column 2
how do i transpose a worksheet with formulas and look up tables in 5
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row 2
Excel Help to copy information from one row at a time to another sheet 1
How can I move data from a row range to a column range 4
Diplaying rows into columns 1
Columns as Rows 2
Transpose Large Column to Row 2

Back
Top