How to sort empty values at the end the table? (via customSort?)

Hello,

We're using MUIDataTable for a while now, because that's the best table-oriented component the previous front developer had chosen.
Now he's not here, we have to try our best to make it meet our users' expectation.

That's why I'm opening a few issues regarding various aspects of customization of MUIDataTable.
For this purpose, I've forked your Codesandbox and created a little showcase of all our issues:
https://codesandbox.io/s/muidatatables-misc-requests-4vkxk

Some columns can have no data (either empty string or null), and nothing get display: it's OK for us.

We have set a default (ascendant) sort on the "New Role" column.
In our example, the first 2 rows with "New Role" = empty appear at the top of the table.
We want them to appear at the end of the table (i.e. on page 2), the same way it's possible in SQL (at least on Oracle) to ask for `NULLS LAST`.

I suppose this is not feasible "by default", so probably will require implementing a `customSort`.
But how can we implement such a function without implementing a full default sorting function from scratch? I mean, would it be possible to simply re-use the default MUIDataTable sort function?

Start by inspecting the linked CodeSandbox and the MUIDataTable customSort option, then trace how the default sort behavior is exposed. The work is done when empty strings and null values sort to the end in ascending order without requiring a wholly separate sorting implementation, while the existing ordering behavior remains intact.

Written by the indexing model from the issue text.