changing rows insted of columns

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

Guest

Hello

I have an excel sheet with some information on it which has 3 column but
lots of rows. I prefer to change order (reversing the information on column
and rows). Is it possible?

Thanks
BHR
 
Look at TRANSPOSE function.

It is possible but remember you only have 256 columns so if your number of
rows is greater than this, a simple transposition will not work.

Can you let us know the exact range of data and how you want them transposed.
 
Look at TRANSPOSE function.

It is possible but remember you only have 256 columns so if your number of
rows is greater than this, a simple transposition will not work.

Can you let us know the exact range of data and how you want them transposed.
 
Hi

Select your range, and copy it.

Select a cell as leftmost upper corner of new datarange (NB! old and new
datarange must NOT intersect), and then PasteSpecial with Transpose checked.
 
Hi

Select your range, and copy it.

Select a cell as leftmost upper corner of new datarange (NB! old and new
datarange must NOT intersect), and then PasteSpecial with Transpose checked.
 
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
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
using the =page! feature to transpose a row to column 0
Match and delete rows on two different sheets from reference numbers 4
count & If fomula 5
Compare identifier columns from 2 sheets - remove rows that are dups 2
Look up a value from a row after verifying two other values 10
Moving Column data formula 1

Back
Top