Transpose a table
 

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?

Transpose a table
 

In A1 did you type: =Sheet1!$C$3 ?
Micky

"kbr" wrote:

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?

Transpose a table
 

yes...

"מיכאל (מיקי) אבידן" wrote:

In A1 did you type: =Sheet1!$C$3 ?
Micky

"kbr" wrote:

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?