Forum Discussion
Convert txt file to Excel
We were provided Tax delinquent data from our County in a txt file. The file contains 2 types of records (SCNDELQ and SCNINST)..example attached. The 2 types of records are layed out in different for...
That's the job for Power Query - query txt file, separate on two filtering by code, split on columns by positions and return both tables to Excel sheet.