Sorting data with blank record

Help
, , ,
1

I have an Excel Sheet with 5 Columns, Data looks like

Id | Name | Age | Due Date | Pending Amount
1 Bravo 28 09/01/2019 $100
2 Alpha 31 09/03/2019 $125
3 Delta 34 09/05/2019 $75
4 Kilo 09/05/2019
5 Charlie 26 09/04/2019 $90
6 Lema 09/05/2019
7 Tango 24 09/07/2019 $150

I want to Sort the Data on multiple Columns i.e. Name, Pending Amount, Age & Due Date.

When I do it Manually in Excel with Custom Sorting I get a different result set and when I am using Datatable sorting OR DataView sorting I am getting different results because of the Blank Cell in Age and Pending Amount. The Blank Cell Rows is Always coming to the Top. Any Suggestion on fixing the Blank Cells in Sorting?

2

Hi @atul.trikha

Add ‘0’ to Age column blank cell and then do sort