Multiple Row Sorting in Matrix

[Anonymous]

Need to sort row on the basis of their rownumber instead of alphabetical order

[djurecic]

Also, if you need to, you can add an index column using Power Query:

[Anonymous]

Thanks for the solution.

But problem here is, rows has multiple values like a hierarchy.

In attached screenshot, highlighted rows are getting alphabetical sorted. I want to sort on the basis of row number.

[Idrissshatila]

Hello,

to do that you need to sort the column that you want to use by the sorting number in the Data view.

you click on the column then in the column tools tab click sort by column and sort it by the sorting column number

as you can see in the screenshot.

If I answered your question, please mark my post as solution, Appreciate your Kudos!

Follow me on Linkedin

[Anonymous]

Thanks for the solution.But problem here is, rows has multiple values like a hierarchy.

In current case, rows are getting alphabetical sorted. I want to sort on the basis of row number.