Transpose a formula

[Sharkie21]

Is it possible to transpose a formula so I can make excel fill it in for me?

ie:

Worksheet 1

A B C D
Jan 10 50 11
Feb 20 30 14
Mar 30 20 13
Apr 40 10 123
May 50 1 12

Worksheet 2 ( I want)

Jan Feb Mar Apr May
=wk1!B1 =wk1!B2 =wk1!B3 =wk1!B4 =wk1!B5
=wk1!C1 =wk1!C2 =wk1!C3 =wk1!C4 =wk1!C5
=wk1!D1 =wk1!D2 =wk1!D3 =wk1!D4 =wk1!D5



I don't want to input each of these formulas manually... And if I do auto fill it gives me (Don't want this!)


Jan Feb Mar Apr May
=wk1!B1 =wk1!C1 =wk1!D1 =wk1!E1 =wk1!F1
=wk1!B2 =wk1!C2 =wk1!D2 =wk1!E2 =wk1!F2
=wk1!B3 =wk1!C3 =wk1!D3 =wk1!E3 =wk1!F3

 

[Aladin Akyurek]

Worksheet 2...

A1, copied across and down:

=INDEX(wk1!$A$1:$D$5,COLUMNS($A1:A1),ROW()-ROW($A$1)+1)