Good morning,
I am trying to do something I could swear I have managed in the past, but cannot for the life of me remember how.
In column B I have a list of mainly blanks, but with a few values (text) in between. What I would like to do is show these values in cell C1 downwards, without the blanks.
So:
Column B
Test 1
Test 2
Test 3
Test 4
Column C:
Test 1
Test 2
Test 3
Test 4
Does anybody know which function I should be using for this?
Many thanks.
Bookmarks