Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Pivot & Unpivot
Reshaping tables by pivoting/unpivoting.
Pivot Table by Agent
Challenge No. 173: Pivot the given table as shown.
Solved using: Python.
Unpivot and Merge Names
Challenge No. 132: Unpivot the problem table into result table.
Solved using: Python in Excel.
Create half-yearly sorted table from data
Challenge No. 340: From dataset in column A, create the table under Answer Expected.
Solved using: Python in Excel.
Split and Pivot Data
Challenge No. 34: Split and pivot the Orders table
For example, Fred has only 2 Orders on the 14th and 15th Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Pivoting Data
Challenge No. 22: Pivot the Customer’s table
Create a Total for each Month
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.