That will work for a small sample test data but there are over three thousands rows, that will be a lot of "Select ......... Union all" statements.

select [Invoice Number],
       [Invoice Date],
    [Dept#],
    [Loc#],
      [Category#],
    [GS]  as 'General Store',
    [Regfee] as 'NE Regional Fees',
    [PCOST] as 'Pacific Fees',
    [OfficeFee]...

I have the values displaying from left to right, the dynamic Pivot works, but if I want add an additional column to be the total of the months
 I would have to...

Thanks works, I forgot about the Pivot function.

I see were you going but the problem with your example it's basically repeating the code, Network will be the same as llcode but with one character missing.
attach is some...

Yes I'm sure that's the key(id) and the columns I want from tblB are Cost & TotalCost.  Their are no null values in that column.

Thanks guys just doing this works " 

CAST((pwdlastset