K
kbr
How do I transpose a table whose values are created by referencing on to a
different spreadsheet and not by typing.
example- A1 in sheet 2 refers to C3 in sheet1
A2 in sheet 2 referes to D4 in sheet 1
Now how do I transpose A1, A2 to B1 , B2.
I used the transpose command but the tranposed table generates " #REF" and
not the values.
can anybody help?
different spreadsheet and not by typing.
example- A1 in sheet 2 refers to C3 in sheet1
A2 in sheet 2 referes to D4 in sheet 1
Now how do I transpose A1, A2 to B1 , B2.
I used the transpose command but the tranposed table generates " #REF" and
not the values.
can anybody help?