G
Guest
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.
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.