Thanks for the help! I tried the first one and for some reason it did not work (then my computer crashed and I lost all my data!). The pivot table looks like what I need. Thank you again!!