Get & Transform Data | Get Data from a folder transforming the files before the combination

Hello,

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.

2-Unpivot columns.

How can i do this with Power Query before combining them in a massive way?