I am working on two lists for work and I would like to make it easier to consolidate it. What I want to do is take two lists and make a third that combines them as one. However, I want it to be based on criteria of "In Progress" housed in another cell once it no longer says that I would like the third list to remove that and then shift the list up. Once all items have been completed it then has nothing on the third sheet. Is this possible? What would I use?