EXCEL – table to list for mail merge

I’m helping a group update a competition score sheet and need help converting a table with gaps to a list.