Aligning rows, across 3 columns

Hi Guys,

I am working on some data that is split into 3 columns, and shows the number of graduates of each course either, A-Working full time D-Working part time, looking for full time work G-Not working, looking for full time work.

I am trying to calculate the totals e.g Working full time + Working part time + Not working, for a Bachelor of Accounting but because the rows are not matched up I will have to go through manually and match them up.

Does any one know how I can match the rows up by the name? Or get a sum out with out matching them? I have attached a file with the numbers removed and replaced with 'x'.

Your help is greatly appreciated,

Simon