I don't think a pivot table would work. I posted a very simple worksheet. My actual worksheet will have 20 additional columns of information that will get broken out into seperate tabs based on the names. I need to make sure I have a certain number of records for each person before I start manipulating the data.