How to Sort Values from a List

GOAL 

A list contains values in an unsorted order.

Order the values in a list. 

Learn

To sort values from a list, two different approaches are available.

It is possible to do this in several steps and worksheets: 

Sheet1

• Have a column with the list.
• Add a cloumn with formula GROUPYBY(1).
• Use GROUPROWNUMBER to create a column with the ListID.

Sheet2

• EXPAND the list from Sheet1.
• Copy the column with the ListID from Sheet1.

Sheet3 (Option A)

• GROUPBY(ListID).
• GROUP_SORT_ASC or GROUP_SORT_DESC on the expanded individual records from Sheet2.

Sheet3 (Option B)

• GROUPBY(ListID).
• Use GROUPCONCAT on the expanded individual records for both values from Sheet2.

or 

• SORT the list in numerical or alphabetical order.