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

Hi Jpola. Welcome to the forum.

Try applying filters. Filter on the blanks in the 6th field. Select all those records and delete them.

Does that do what you want?