I'm sure this question has a very simple answer that I should know, but don't. In the cells of column A are either a number or blank. The numbers appear every so often, with the blank cells in between. In column B I want to just show the numbers. Example:
Column A Column B
How do I generate column B?