Hello,

I am trying to figure out an excel formula to help me return all non-
blank values from one column into another. I'd like it to look like
the below example. All values from column A listed sequentially in
Column B with no blank spaces.

A B
1 TEST1 TEST1
2 TEST2
3 TEST2 TEST
4 BTEST
5 NOSE
6 TEST
7
8 BTEST
9
10 NOSE

Additional information:
The information in column A is text and is referenced from another
sheet and will change from time to time. The results in Column B
should also update.
I've tried multiple IF statements but that just gets messy very
quickly. Plus, it still didn't do what I needed it to.

I would appreciate any and all help you can give!!! Thank you!!

Matt