Power Query - How do I remove rows below a table with a similar dataset.

[Wikimart]

I just started using Power query so my knowledge is very basic.
The problem: When filter my data (data comes from MS Word and has tables in it) the results show data that similar to the rest of my output which makes me have to clean the data though a macro or though manual intervention It wouldn't be a problem if there were a few, but I'm getting hundreds of these data files a week - To add to the issue the data in each file is different.

+Making a macro in excel to do this adds to the complexity, so I'd like to avoid that route unless there is no other option.


After a clean my data as best I can, I get the following results for the example below. I want to delete any and all Rows (dynamically) after line 14 "BRU and Monthly Recurrent Cost" .

Help!

 

[JGordon11]

= Table.FirstN(Source, List.PositionOf(Source[Column1], "BRU and Monthly Recurrent Cost") +1)

Change Source[Column1] to the step name and column name for your query

 

[Wikimart]

Thanks for the quick reply to my issue, I've run into some what I would call skill issue on my side, did I at least put the code in the right place(See image for result)

• The Step name FRows
• Code adjustments based on your comments (I think I fudged that up too )
  • = Table.FirstN(FRows, List.PositionOf(FRows[Column1], "BRU and Monthly Recurrent Cost") +1)

 

[JGordon11]

You've put two steps in one step. Delete the =Table.FirstN... stuff in the FRows step. Then with the FRows step selected click the fx button and put the =Table.FirstN... stuff there

 

[Wikimart]

Worked like a charm, thank you so much!

 

[Wikimart]

hi JGordon11: How would I delete all the rows above using a similar code?

 

[JGordon11]

= Table.Range(Source, List.PositionOf(Source[Column1], "BRU and Monthly Recurrent Cost"))

 

[Wikimart]

This is great, thank you.