Report/Table with 2 summary

I have a situation that I can not figure out how to get resolved. I dont think a pivot table is the answer.

I have an excel sheet with around 1500 'products' The name of the product is not unique for the entire database. Once a name is added to the data base it will not change. So the total population will increase, never decrease.

Each product falls into 1 of 7 lines of business (LOB), The name of the product IS unique within a LOB. The LOB for a specific product name will not change.

Each product falls into 1 of 4 status : Development, UAT, Live, Retired. The status for a product WILL change.

What I want is a report, that has the ability to refresh when either the status changes or a new product is added. I want a break down of the product name by LOB and by status. Something like the attached (note I an not stuck of this format)

excelform.JPG

Any ideas as how to accomplish this?

Have you considered creating an additional column called LOB, and then for each product write LOB 1, LOB 2, or LOB 3? That way, you can keep adding forever using only 5 columns, and use the Refresh Pivot option to update when you refresh LOBs