how to change coloum to row

[Guest]

hi

in one of my application i need to change my colum data to row data
is there any formula to resolve this

i had tried TRANSPOSE option but i had not able to do it

please help me to over come this problem

thanks in advance
regards
sangeet

 

[Guest]

When you did transpose did you copy just the data in the column or the entire
column?

 

[Guest]

Are you changing a single column to a single row? What are from/to ranges?

Copy=>Paste Special=>Transpose

should work.

 

[Guest]

Sangeet,

Only copy the data you want to transpose not the entire column or you will
get an error.

Mike

 

[Guest]

if the column has equations which use relative and not absolute references,
the paste special transpose will give you problems.
give an example of the ytpe of data you want to transpose and from where to
where, and we can probably give some suggestions.

 

[Guest]

i had tried TRANSPOSE option but i had not able to do it ..

Assume you are trying to make a dynamic transpose
of Sheet1's A2:A4 in Sheet2's B11 using TRANSPOSE

In Sheet2,

Select B11, then put in the formula bar:
=TRANSPOSE(Sheet1!A2:A4)
Array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER)