I do want to take the entire row of P and stick it below O. I just don't know how to do it that way because O will have empty cells but there will be cells with content after those empty ones. So I will never know which is last cell in O just by checking if a specific cell is empty or not, because if it is empty, that doesnt necessarily mean that it is the last. I also dont want to override any cells with content in O but I want to also ensure all the Ps end up in O. It is really something simple I am trying to do:
The results after the macro:
Bookmarks