Re: ]] XL-mania [[ Transpose Function.

[Afda Rizki]

Hi Arora,

My two cents :)





2. then press Ctrl + Shift + Enter all together (in the same time)



4. copy-paste to another remaining cell

Maybe you need to make some cells to be absolute.

Hope it will help you

Regards,
---
Afda

*****


Arora, Aman (GE Money) wrote:

Simply use array formula ( Ctrl + Shift + Enter ) while using TRANSPOSE, here are the steps : 1. when you are here --> =TRANSPOSE(B2:J15) do not press enter or just Press F2 3. the formula will be shown like this : {=TRANSPOSE(B2:J15)} and it has a result

Hi All,

Aman S Arora

This transpose function is not working, Can you please hemp me for same. Regards

Arora_TRANSPOSE.xls
Description: MS-Excel spreadsheet