I want to extract everything not equal to "GOOD" from this list and
place the results on another column next to it with no blank rows.
Thanks.

Column A Column B
======= ======
GOOD 456
GOOD 123
GOOD 2599
456 2489
GOOD 549
GOOD
123
GOOD
GOOD
2589
GOOD
GOOD
GOOD
GOOD
2489
549
GOOD
GOOD
GOOD
GOOD