Looks very doable with Pivot table, If you can send sample data over, I can work it out.