Thanks Peco

This worked perfectly!! Not sure why I didn't think of this. It never crossed my mind that I could do a pivot table to solve this quick and easy....