Looking for the best way to condense table with blanks

Alan, thank you for your solution. We're NEWBIE's at Excel, so code is a stretch for us, but we're going to try to make it work.

Thank you for your help! Very much appreciated!