Syntax
GROUPSELECT(<any>;<any>;<any><any>;<any>)
Description
Create columns with selected values using a key constant from a specified grouped column in the workbook.
...
This is a excellent tool to create columns for use in a pivot table.
This is an aggregate function.
...