| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose data and retain links to original data
Hi
I know this topic has already been raised but I am not sure I understood any of the answers. I am a novice where functions like OFFSET and INDEX are concerned. What I would like to do is transpose horizontal data from Sheet1! row $C$4:$CB$4 and place it in Sheet2! column $G$10:$G$61 while retaining the links to the original data in Sheet1!- how do I do that? What is the formula which will produce this result. Regards Neil |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Transpose data and retain links to original data
Try the below formula in G10 and copy down to G61.
=INDEX($C$4:$CB$4,ROW(A1)) If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: Hi I know this topic has already been raised but I am not sure I understood any of the answers. I am a novice where functions like OFFSET and INDEX are concerned. What I would like to do is transpose horizontal data from Sheet1! row $C$4:$CB$4 and place it in Sheet2! column $G$10:$G$61 while retaining the links to the original data in Sheet1!- how do I do that? What is the formula which will produce this result. Regards Neil |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Transpose data and retain links to original data
=OFFSET(Sheet1!C$4,0,ROWS(G$10:G10)-1) and copy down,
but of course you need to go to G87 (not G61), if you want to go as far as CB4. -- David Biddulph "Neil" wrote in message ... Hi I know this topic has already been raised but I am not sure I understood any of the answers. I am a novice where functions like OFFSET and INDEX are concerned. What I would like to do is transpose horizontal data from Sheet1! row $C$4:$CB$4 and place it in Sheet2! column $G$10:$G$61 while retaining the links to the original data in Sheet1!- how do I do that? What is the formula which will produce this result. Regards Neil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fetching data and deleting original data | New Users to Excel | |||
| Switch to change data fields to 0's, then back to original data? | Excel Discussion (Misc queries) | |||
| Change number of decimals but retain original style | Excel Discussion (Misc queries) | |||
| Data depiction/transpose and retain formulas | Excel Worksheet Functions | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Linear Mode
