Look for unstructured data - complex

Hello,

I have what I believe to be a complex query which, I hope, someone will be able to help. The purpose of my exercise is to select data from a particular column to a different sheet. An example is listed below:

Code Units Total
A05251
-pur 16 2005156
-rem 6 810595
Total 22 2815751
A03626
-pur 41 6219082
-rem 2 212250
Total 43 6431332
A02996
-pur 2 182000
Total 2 182000
A09412
-rem 2 190000
Total 2 190000

What happens however is that the results displayed are not consistent. Today I may have "pur" and "rem" under a particular code however tomorrow that may not be the case and I will have only one of the two or none. In this collumn there are hundreds of codes which start with a diferent letter however I am only interested in the codes starting with "A" and the respective pur and rem results. What I am looking into doing is listing the information in a different sheet, preferably by having all the possible "A" codes with the resptive "pur " and "rem" and total for each "A" code and then fill it in daily with whatever comes from the sheet where the above info is.

Any assistance would be most appreciated.

Many Thanks!