Formula for transposing Row Values to Col Values

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

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
 
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...
 
Enter this *anywhere* and copy down as needed:

=INDEX(Sheet1!$L$2:$Z$2,ROWS($1:1))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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
 
Back
Top