I have matrix of data (20 rows and 10 columns) and I want to transpose this
matrix.
Up to this point it is easy but what makes it difficult is that the original
matrix contains formulas in each individual cell and I want the original
matrix and the transposed version of it to be linked to each other. In other
words if a cell's value changes in the original matrix I want the
corrosponding cell in the transposed matrix to take same value automatically.
I tried to do this using absolye and relative references but it did not work.