Deleting rows from date after key words in column

[wbstadeli]

Hi all,

I was wondering if this would be possible to do, and if so how to apply the correct steps in the power query to achieve it? The Query pulls a certain sheet from a workbook, lets call it sheet1, loads the contents of that worksheet, and then in column 5, IF there is the words "Lathe Machining:" i want to remove that entire row and any row underneath that cell in the workbook. The reason i say "if" is because there are different workbooks that some had a slight variation of design and one design added this cell with values below it which throws off my data that im trying to import above the cell "Lathe Machining:". It would be a great help if someone would be able to help me with this!

Thanks!

 

[VBA Geek]

I am guessing you want to do this in Power Query. Can you post a sample of data along with expected result?