A list contains values in an unsorted order.
Order the values in a list.
To sort values from a list, two different approaches are available.
It is possible to do this in several steps and worksheets:
- Have a column with the list.
- Add a cloumn with formula GROUPYBY(1).
- Use GROUPROWNUMBER to create a column with the
- EXPAND the list from
- Copy the column with the
Sheet3 (Option A)
Sheet3 (Option B)
- SORT the list in numerical or alphabetical order.