Thanks for the tip! I had never looked at Pivot tables before (as I said, still new to Excel beyond SUM and the like), and I'm halfway there. Unfortunately, the entries that it is giving me in the table values are the count of how many vendor numbers exist for a given vendor and part number. Any suggestions on how to get it to actually display the vendor numbers? Thanks again.