How can you sort rows in a data table based on a hierarchy/multiple of criteria?
I need to sort a data table using a hierarchical/multiple criteria. For example, imagine a table table that has clients listed in one column and location of the client listed in another column. With that being said each client can have more than one location so there may be more than one row for each client name.
What I would like to do is sort the list in ascending a-z order by client name, then keeping the client name in a-z order I would then sort the location secondarily in z-a descending order for each client respectively. I know that this can be done in excel natively, so I have attached an example file of how this would look, If you look at the sorts feature in the excel file you will see the criteria depicted.