Align data in columns by last row

I'm working with another program to import data into excel. Each column corresponds to an individual with annual measurements. Every individual has a different starting age, and when the measurements are imported, they are aligned according to their starting year measurements (all in row 1). I need to instead align each column according to the final year's measurements. Is there a simple formula or tool I can use to realign each column according to the last row of data entry.

Data currently looks like:
Ind. A Ind. B Ind. C Ind. D
1 3 5 7
2 4 6 8
3 5 7 9
9 7 8 5
5 8 9 2
3 9 10 7
7 9 8
8
9
14


Ind. A Ind. B Ind. C Ind. D
1
2
3
9 3 7
5 4 5 8
3 5 6 9
7 7 7 5
8 8 8 2
9 9 9 7
14 9 10 8

Hi this Macro will do what you need.

Please Login or Register  to view this content.