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

Sheet2

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

Sheet3 (Option A)

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.