Pivoting

[norberttech]

GroupBy could also allow pivot tables.

From:

+------+---------+------+
| Year | Product | Sale |
+------+---------+------+
| 2019 |   A     | 100  |
| 2019 |   B     | 200  |
| 2020 |   A     | 150  |
| 2020 |   C     | 300  |
| 2021 |   B     | 100  |
| 2021 |   C     | 150  |
+------+---------+------+

Through:

• Group by Year
• Pivot by Product
• Aggregate Sum by Sale

Into:

+------+----+----+----+
| Year |  A |  B |  C |
+------+----+----+----+
| 2021 |null| 100| 150|
| 2019 | 100| 200|null|
| 2020 | 150|null| 300|
+------+----+----+----+

[norberttech]

I changed the title since I don't think that Pivot can be achieved through expressions, I think it needs to be added directly into GroupBy - just like Aggregations