Diagonal and upwards transposing

[Guest]

Hi

I am trying to do a look up of sorts onto a large table of mortality rates
and essentially want to transpose what I have in one table so I get the
following in another (example given based on a 4x4 square):

A4 A3 A2 A1
B5 B4 B3 B2
C6 C5 C4 C3
D7 D6 D5 D4
etc...

Does anyone have any ideas as to the simplest way to go about this?

Any assistance much appreciated.

Thanks

 

[Guest]

Source data assumed within A17

In any starting cell, say in F9:
=OFFSET($A$1,ROWS($1:1)-COLUMNS($A:A)+3,ROWS($1:1)-1)
Copy F9 across/fill down to I12 to populate a 4 x 4

F9:I12 will return the contents of the cells in the desired manner:

A4 A3 A2 A1
B5 B4 B3 B2
C6 C5 C4 C3
D7 D6 D5 D4

---

 

[Guest]

Fantastic - thanks so much!

Source data assumed within A17

In any starting cell, say in F9:
=OFFSET($A$1,ROWS($1:1)-COLUMNS($A:A)+3,ROWS($1:1)-1)
Copy F9 across/fill down to I12 to populate a 4 x 4

F9:I12 will return the contents of the cells in the desired manner:

 

[Max]

welcome