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