Data exports to a csv file with 6 fields, need to sort data

Hello everyone,
I have been able to export a list from an old windows program that exports to exclusively Excel CSV files. There are over 8 thousand records and it exports into 6 different fields.

The CSV file opens in Excel 2013 and I was hoping to sort the data in a certain way: I want to delete or relocate all of the data that contains a blank 6th field. To rephrase any record that has 6th field with no information inside of it, I would like removed or separated from the data that does.

Please let me know if you understand what I am asking, and can clarify further if needed.

Any help will be greatly appreciated
Thankyou