Challenge No. 660: Insert the sum for the year after the year ends.
Solved using: Python.
Table.Combine
Merges multiple tables into a single table in Power Query.
Insert Quarterly Totals
Challenge No. 646: Insert Quarterly total line after Mar, Jun, Jul and Dec.
Solved using: Python in Excel.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
Unpivot the table, add order
Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
Pick top N by group
Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
Summarise the table with total
Challenge No. 266: Summarise the table as shown with a total row after each sales person’s data.
Solved using: Python.
Populate the addresses for Greek
Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.
Reformat Item Entries
Challenge No. 242: Transform the problem table into result table as shown.
Solved using: Python.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Subject Scores Transposition
Challenge No. 223: Transpose the problem table into result table.
Solved using: Python.