• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

help with excel transpose table

A

asafraz81

Member
hi there

i want to transpose table (move axis x-becomes y and inversely)

i know that i can do it with special paste, but i want it to be dinamic.

I would appreciate your help in kind

asaf
 
asafraz81,


The word dynamic can be interpreted in many ways! I am assuming that any change in original array shall be reflected in the transposed array.


You can try transpose formula e.g.

1. Put some data in A1:B10 (2 columns X 10 rows) which will be data to transpose.

2. Then select range C1:L2 (10 columns X 2 rows) and then control + shift + enter following formula:

=TRANSPOSE(A1:B10)

3. Correct entry will enclose above formula with curly braces ({}) and then if you change anything in A1:B10 then changes will be reflected in "transposed array".
 
You must log in or register to reply here.
Back
Top