The following operations can be performed with the Shape Tool:

Each of these operations are explained in the Data Shaping Tool.

See Group By Aggregate Function for details of the supported aggregate functions.