Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for transposing Row Values to Col Values
Excel2003 ...
WS1 ... Row Range L2:Z2 ... Contains Text WS2 ... Col Range B3:B17 ... I wish formula to populate Text from WS1 == I know I can do this with Copy/Paste/Special/Transpose ... However, I wish a Formula to do it as I need to apply in additional places ... Thanks ... Kha |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for transposing Row Values to Col Values
One way...
With Values in A1, B1, C1... use this formula in A3 and drag down =OFFSET($A$1, 0, ROW() - 3, 1, 1) Note that this function is volatile and as such will add a lot of calculation overhead to your spreadsheet. If you use a lot of these your performance will suffer... -- HTH... Jim Thomlinson "Ken" wrote: Excel2003 ... WS1 ... Row Range L2:Z2 ... Contains Text WS2 ... Col Range B3:B17 ... I wish formula to populate Text from WS1 == I know I can do this with Copy/Paste/Special/Transpose ... However, I wish a Formula to do it as I need to apply in additional places ... Thanks ... Kha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transposing Multiple Cell References to Multiple Values (NOT total | Excel Discussion (Misc queries) | |||
Transposing Multiple Cell references as Multiple Values | Excel Discussion (Misc queries) | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
transposing values top to bottom | Excel Discussion (Misc queries) |