Formula for transposing Row Values to Col Values

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
 
J

Jim Thomlinson

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...
 
R

RagDyeR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top