I have a worksheet in where I have table (let's call it the summary table) with references to a another table (among others) which is 2x40 (rows x columns).
I would like to tranpose this into a 40x2 table.
So, first I copy tha 2x40 and transpose it using Copy and then Paste Special -> Transpose (or using the TRANSPOSE() commando).
Then I would like to delete the 2x40 in order to avoid a dobulet of the information.
If I do this, the summary table will lose its references, since whatever value was in the now deleted table - the 2x40 is gone. However, the information is still availiable, but is now in the 40x2 table.
The easy solution would have been to CUT and then Paste SPecial -> Transpose, since the links are "dynamic" whenever I cut something.
But Excel cannot do that for transposing for some reason.
So.. i'm out of ideas, except changing the summary table.
Is there anyway to go about this without having to change the references in the summary table?
I would like to tranpose this into a 40x2 table.
So, first I copy tha 2x40 and transpose it using Copy and then Paste Special -> Transpose (or using the TRANSPOSE() commando).
Then I would like to delete the 2x40 in order to avoid a dobulet of the information.
If I do this, the summary table will lose its references, since whatever value was in the now deleted table - the 2x40 is gone. However, the information is still availiable, but is now in the 40x2 table.
The easy solution would have been to CUT and then Paste SPecial -> Transpose, since the links are "dynamic" whenever I cut something.
But Excel cannot do that for transposing for some reason.
So.. i'm out of ideas, except changing the summary table.
Is there anyway to go about this without having to change the references in the summary table?