Sort by column name

When you sort by ascending on a text column it shows numbers first. And it only sorts by the first element of some text.

An example:

data = beer, 3, 10, 2, axe, cloth.

Sort data by ascending: 10, 2, 3, axe, beer, cloth

Sort data by descening: cloth, beer, axe, 3, 2, 1

These are the possibilities you have when sorting text. but there is a work around for this.

You can make a new column next to your categories, which can be called SortOrder and simply assign 1, 2, 3, 4, 5 and so on, and then sort by the column, either ascending or descending according to your need. 

Let me know if this will solve your challenge. I'll gladly elaborate.

Best

Martin

barabuli Could I ask you to accept a solution for this so other can benefit from it as well?