changing rows insted of columns
 

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

changing rows insted of columns
 

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.


"Bahareh" wrote:

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

changing rows insted of columns
 

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.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Bahareh" wrote in message
...
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