| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to transpose a table into two columns? | Excel Discussion (Misc queries) | |||
| How to transpose the table below into 1 (actually 2) column with t | Excel Discussion (Misc queries) | |||
| Transpose a data table | Excel Discussion (Misc queries) | |||
| Can you transpose 1 column into multiple rows creating a table | Excel Discussion (Misc queries) | |||
| transpose a table | Excel Discussion (Misc queries) | |||
Linear Mode
