Disable Column Sorting

[Anonymous]

Dear Community,

I need help with the following use case. I have a similar dataset and would like to put same in a table.

Name      Age     Marks 

Jon          18         72

Garry       15         89

Abhi        22         91

I want the data to be printed exactly the same, without any sorting at Name, Age or Marks columns. 

Thanks in advance!

[FrankAT · Accepted solution]

Hi @Anonymous ,

1. Add an index column in Power Query.

2. Sort column Name by column Index in data view.

3. See figure.

Regards FrankAT