Forum Discussion
Dynamically delete rows in column
Hi guys, I am looking for a way to dynamically keep a range of rows in power query. I have multiple standard worksheet files that are combined in one query. But the data starts at a different ro...
Add index column since you already know the starting row of dataset.
For this example i do know indeed but for the other 200 files i do not know the starting row of the data and it would be nice if that coould be automatically solved...