Hi - I'd recommend using the PIVOT function in Excel for collapsing duplicate data into summary forms. This link might help if you've not used this in the past:

http://msmvps.com/blogs/harrywaldron...t-a-table.aspx