Is there a "formula" that I can put into RowB that will remove the blank
cells from RowA without sorting or manually copying and pasting?
I posted this earlier but didn't get an anwer if there is a formula or not.

Example:

A B
1 8 8
2 6 6
3 2
4 2 5
5 5 6
6 6 4
7
8
9 4

Thank you for your help
Luke