I have an excel list. Rows till 4000 and columns till M. From A to L there are values in all the 4000 rows. But M column has values for may be 1000 rows only and that too in random.
My question is how can I make the blank cells of the M column appear first in the list with its corresponding rows followed by the rows which have A to M with values.
Please let me know.
My question is how can I make the blank cells of the M column appear first in the list with its corresponding rows followed by the rows which have A to M with values.
Please let me know.