Hello all,
I am trying to sort a range of cells A1:D3 in ascending order but while doing so, omit the blank cells and keep them at the end of the end of the range. Is something like this possible? I tried searching how to sort by ranges but all i have found is how to sort by columns or rows.
I attached an example of what i am trying to accomplish.