Save it before you try this!

As long as there are no duplicate files I think this should work.

Highlight column A, go to the Data tab, click the 'Remove Duplicates' button in data tools.

This should remove all gaps, bar the first one which you can do manually.