Sort output labels by value ascending

[AdrianJuarez]

Looking for some input regarding the expression required to sort output labels (ascending) based off of a specific value. I have a table of ethnic population values for administrative districts (row) and ethnicities (column). I have attached a sample table for reference. Any help is greatly appreciated.

[SepheFox]

Hi Adrian,

I'm not certain what you mean by "the expression required", but you can either sort by right clicking the field heading in the attribute table, or using the Sort tool: ArcGIS Desktop

[AdrianJuarez]

Sorry for not going into greater detail. What I am trying to do is use a label expression via layer properties to sort through columns within my table then sort the output labels on my map based off of values ascending. I am aware of the sort ascending / descending within the table / feature class, I think what I am trying to do is a bit more than that.

[SepheFox]

Did you look at the Sort tool I mentioned? It creates a new feature class which is already sorted.

[AdrianJuarez]

We are only licensed at the basic level within the org I currently support.  I am going to try this at home later tonight. Thanks for the info.

[DarrenWiens2]

You are talking about sorting columns, not rows, correct? For example, in your spreadsheet, "Armenian" would always come first.

[AdrianJuarez]

Darren, I have attached an example of my current labeling expression and what my labeling currently looks like.

" Armenian: " & [Armenian_M2] &vbnewline& "Aromenian:" & [Aromenian_M2] &vbnewline&...etc

Armenian: 5%

Aromenian: 12%

Greek: 30%

Macedonian: 2%

This is what my output labels need to look like and I would like to use the label expression to make it happen. Sorted by values descending

Greek: 30%

Aromenian: 12%

Armenian: 5%

Macedonian: 2%

[SepheFox]

Oh, now I see what you are trying to do! It looks like these folks did just that, using  a field called "top_depth_inches" to sort the label: Displaying a multi-row table label in ArcGIS using Python | wolfmapper