Pivoting tables

Use Case

You need to PIVOT table data in Table Transformer.

Solution

1. Switch the page to the edit mode.
2. Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.
3. Select the macro and click Edit.
4. In the Presets tab select Custom transformation and click Next.

5. Enter the following SQL query:

   SELECT * FROM T1
   PIVOT (MAX('Value') for 'Month')

   CODE
6. Save the macro and the page.
   
   

The aggregation function MAX is applied to an existing column Value. The Month column is the column the data are aggregated by.

The same output can be produced with the Pivot Table macro with versatile functions like MAX, MIN, SUM, etc., specifically designed for easy and accessible table data aggregation.