I appended multiple power queries into one table because I am working with more than one worksheet. Please see my example image below. When I delete the data for Bob and Betty from the “Blueberries” worksheet it causes the power query results from the row “Lettuce” to move up into the row for “Blueberries”. How do I prevent that from happening? I want the “Blueberries” row to remain blank when there is no data from that respective worksheet. My example image below:
EDIT: It won’t let me upload an image but I hope there is a link that you can access…
