The Pivoting function pivots data that is stored in rows into columns. It outputs a table whose columns are based on the individual values from an input table column. The output table schema depends on the function arguments. The function handles missing or NULL values automatically.
The reverse of this function is Unpivoting.