How to sort data in excel sheet with month names

[kumar.varun2 (Varun Kumar)]

Hi @Zeba

You can try this

dt_Data.AsEnumerable.OrderBy(Function(r) Date.ParseExact(r("Month").ToString.Substring(0,3), "MMM", Nothing)).CopyToDataTable

The xaml file

SortByMonthNames.xaml (5.1 KB)