I need a way to transform a report into a table to upload to power query automatically. Can power query do this? I pull this report for two locations off the web every month. I would like my query to pull all excel files with sheet named AC Energy from the folder. I attached a sample report for reference. the AC Energy sheet is what is downloaded from web, Table sheet is what I want the information to look like. I can transform the data in power query once it is in table.

Any help is appreciated!

Thanks, Cathy