changing rows insted of columns

B

Bahareh

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
 
T

Toppers

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.
 
A

Arvi Laanemets

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.
 
Top