Hello all,
I am searching for a formula that will only extract the non-blank cells within a column. I would like to extract the non-blanks in column X and place them in column Y as below. An example of my data is below
X Y
- 1234
- 1235
1234 1236
1235 1237
1236 1238
- ...
1237
-
1238
...
If there is not a formula but an easier way that would be great too. Thank you for your help.
Bookmarks