Grouping

Good morning…

Problem 2 - again from a non Navision database. (project management)
I obtain rows from a table which have the following key records.
A Period Code (Numeric)
A country code (alpha 2)
An Implementing agency code (Numeric)
and a Description (text 256)

What I need to be able to do is return those fields grouped, plus ten possible (though not allways) analysis codes, plus the summed budget amount for each of those codes

So curently I have
Period Ctr, imp, desc, Account, Amount
200901, Fj, 15, "Do this activity in that country", "Transport", $3,000
200901, Fj, 15, "Do this activity in that country", "Consumables", $500

I would like to end up with the ability to have
Period Ctr, imp, desc, Transport amount, Consumables amount, Salaries, etc…Other Amount, Total
200901, Fj, 15, "Do this activity in that country", $3,000, $500, $0, $0, ….$3,500

then I will be able to happily compare this to what is actually happening through Navision

Again thanks for your consideration!
Dave