Hello,
I'm using excel 2016 and just wondering if I can use power query to replace a bunch of macros in a reconciliation workbook.

what my macros do is to compile over 50 txt files into one, do some data cleaning and dump the data in a workbook (1st sheet), then go to a different folder to open 50+ CSV files and clean those up and dump into another sheet in the same workbook. then compare the two files using index/match formulas, then add a worksheet and copy and paste the unreconciled items to a that worksheet.

I know I can upload the files onto power query but can I do the comparison part DIRECLY in the query steps so the whole process can be done in Power query?

thanks