| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose with linked data
2 Steps: 1. On worksheet #3 highlight the transpose range, type: =transpose(range2) and press cntrl&shift +Enter. range2= the range of the table on worksheet #2 to be transposed. 2. Put your feet up on the table and smile -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=531894 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Transpose with linked data
John James - thanks for the solution - knew it should be easy but could not
figure it out on my own. -- Bill "John James" wrote: 2 Steps: 1. On worksheet #3 highlight the transpose range, type: =transpose(range2) and press cntrl&shift +Enter. range2= the range of the table on worksheet #2 to be transposed. 2. Put your feet up on the table and smile -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=531894 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Microsoft query data into excel changes linked rows | Links and Linking in Excel | |||
| I have a column of data and I'd like to transpose it to go across. | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| How can I transpose data from a spreadsheet into a form that does. | Excel Worksheet Functions | |||
Hybrid Mode
