Sorting a Sheet with Data inputs from a Power Query and XLookup

I made a work order planning tool for our office that pulls all of its information from our ERP system and helps with our analysis. The first half of the sheet comes from a power query that pulls order information straight from our database and lists it, the second half is a Xlookup that matches our order number to a material review sheet and comes back if we have the material or not. In the middle of these two data sets is a notes column we use to keep track of notes regarding orders.

We noticed if you try to apply filters to both the power query section and Xlookup they cancel each put out. Along with this it was brought up that using the sort function can cause the notes column to become jumbled.

Is there a way to get excel to treat each row as a unified item? Also open to how to possibly solve the filtering problem. Leading thought right now would be to make another sheet that copies everything so excel treats it all as one set instead of a power query section and Xlookup.