Data scrapping with empty column value

When data scrapping an table from a website if first row has empty column value then that column is reordered to last. How to we fix the order of columns while data scrapping?

Can you get get the data into a datatable and try the following

table.DefaultView.Sort = “LastName asc”;

That didnt work. It gives the same output.

Don’t have access to computer now.Check below


I was able to rearrange the “Lastname” column using SetOrdinal method of datatable.


Could you please provide the xaml for the same?