Dynamically delete rows in column

Question

Hi guys,&nbsp;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 row per file.&nbsp; I already have combined the files and i am now working in "Transform sample File". I would like every file to start with 3 zeros and then start with the data in row 316 (see image) and then end with 3 zeros.&nbsp;&nbsp;&nbsp;Can anyone help me with this?&nbsp;

mahoneypat · Answer

Please see this video for one way to do this.
Remove Top Rows and Combine Data from Multiple Excel Files - YouTube
&nbsp;
Pat
&nbsp;

anonymous · Answer

Unfortunately did not work for me. Thank you anyway! any alternatives?

cnenfrnl · Answer

Add index column since you already know the starting row of dataset.

anonymous · Answer

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...

Forum Discussion

Dynamically delete rows in column

4 Replies

Related content

Dynamic Column headers

Dynamic Column Name

column deleted but column exists

Dynamic Variable in Calculated Columns

Dynamic column comparison of last column