Session 3 - How I Automate My Work With Power Query
Join me this Saturday July 16th, at 8:00AM MDT.
This time, I will show you how I transform txt files from unorganized lines to meaning and reliable information, using power query.
During this presentation I will create my query to transform these txt files into a table, that I will connect to 2 other tables.
Once the query is ready, then every month when I receive a new txt file, power query will do the work for me.
I hope that this example can inspire you, to automate your process as well.
Working files available here:
https://drive.google.com/drive/folder...
#MSExcel #PowerQuery