27
Jun
Problem description & analysis: We have a comma-separated txt file that has a total of 10 columns. As certain values of the 3rd column do not have separators, that column is missing and the corresponding rows only have 9 columns, as shown in the last rows: We need to import the txt file to an Excel file. If the 3rd column is missing, use space to fill it and then sort rows by the 1st column: A B C D E F G H I J 3 01-0104-0133 MAYO RONIE #2 202403 2024-03-21 22:51:43.000 1449.49 0 0 8 4 01-0120-0137…