Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
Pivot & Unpivot
Reshaping tables by pivoting/unpivoting.
Pivot Data To Columns
Challenge No. 667: Pivot the data as shown.
Solved using: Python.
Pivot Hierarchical Sublevels
Challenge No. 663: Pivot the data as shown.
Solved using: Power Query.
Unpivot the table, add order
Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
Pivot the problem table into
Challenge No. 251: Pivot the problem table into result table.
Solved using: Python.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Outstanding Loan Day Count
Challenge No. 215: Assuming today’s date is 7-Sep-24, pivot the table as shown for Outstanding loans.
Solved using: Python in Excel.
Matrix Merge With Totals
Challenge No. 213: Merge the 2 tables and pivot them on Item with Total Row and Total Column.
Solved using: Python in Excel.
Add Task Duration to Start
Challenge No. 209: Populate the End dates against all owners in a pivot format as shown.
Solved using: Python.
Pivot for Time Entries by Date
Challenge No. 418: Pivot the given table for Date / Emp ID combinations with Min and Max Time.
Solved using: Python in Excel.