[smason]

I'm not sure the best answer, but a quick workaround in Excel is
select all, click data, filter, advanced filter and check the unique records only button.
I'll think all but one blank line is duplicate, and will filter it.
You can leave it filtered, or copy/paste it into a fresh sheet.