Transpose a table

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?
 
×

מיכ×ל (מיקי) ×בידן

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel transpose and references to cells in other sheets 2
Transpose function 4
fill reference to cells in a row down a column 3
How to macro to relative position 6
Conditional Formula based on current date 5
how to create a copy/paste special/transpose macro? 6
Transpose problem 3
Transpose between sheets 4

Top