Sounds like a pivot table is the way to. Copy and paste special values to get the pivot as pure data. Use GoTo, Special, To fill in the blanks and then finally copy and paste the results as vaues to get a list os standalone values with no blanks. Takes about 45 seconds.