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