Is there a way to have contents of row A placed in row B without the blank
cells and without sorting?

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