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?