I assume I need some ARRAY formula, but not sure how to do it. I have blank cells and cells with a value in column C and Column D is the formula I am trying to make. I want to move all values in Column C to the top of Column D in the order that they are in in Column C with blank cells being on the very bottom. Here is an example
<tbody>
</tbody>
Any help is appreciated.
A PRODUCT | B DATE | C KNOWN PURCHASE FORMULA | D FORMULA TO BRING TO TOP OF LIST |
APPLE 2224 | 7/25 | EGG1013 | |
EGG 1013 | 8/23 | EGG 1013 | PEAR 1321 |
GRAPE 3121 | 4/22 | ||
PEAR 1321 | 2/22 | PEAR 1321 |
<tbody>
</tbody>
Any help is appreciated.