I want to read the files in a folder, but those files needs some transformation before I can combine them with power query. Normally what i would do if all of them were in a table format is to combine them and load but since the data in each file is not fully structure if i do this i won´t get correct data.
I have many files that before the combination need to:
1-Remove the first 10 rows of each since they are empty.
How can i do this with Power Query before combining them in a massive way?