Table data - Sort in descending / ascending order
You can use the table data by t
command. Let's input the country data.
Country Area Population
Russia 17,098,242 145,934,462
Canada 9,984,670 37,742,154
United States 9,833,517 331,002,651
China 9,596,960 1,439,323,776
Brazil 8,515,770 212,559,417
Australia 7,741,220 25,499,884
The source of population data: Countries in the world by population (2020)
Next, input t -Population
in the header form and click array icon between left and right areas. The output table data will be showed in the right area.
Country Area Population
Australia 7741220 25499884
Canada 9984670 37742154
Russia 17098242 145934462
Brazil 8515770 212559417
United States 9833517 331002651
China 9596960 1439323776
The column name with -
prefix means ascending sort according to the column. -Population
is to sort the rows by ascending to Population values.
Descending
The column name with double hyphens --
is to sort by descending. So if you input t --Population
, the below data will be showed.
Country Area Population
China 9596960 1439323776
United States 9833517 331002651
Brazil 8515770 212559417
Russia 17098242 145934462
Canada 9984670 37742154
Australia 7741220 25499884
Sort and get the values by columns
What does t --Area [Country]
command mean? It orders the countries by descending to area, and extract only country names. So the result is that:
Country
Russia
Canada
United States
China
Brazil
Australia