I would like to convert data in Col A to a format in Col B, so that Col B
omits the blank cells in Col A. Is this possible with a formula I can drag
down? For example:

Col A Col B
1 1
2
2 34
34 5
5 6
9
6 7
9

7