Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
By Topic
Challenges categorized by topic.
Fill Missing Monthly Values
Challenge No. 698: Populate all months of the year.
Solved using: Python.
Create 2025 Broadcast Calendar
Challenge No. 695: Develop Broadcast Calendar for 2025.
Solved using: Python.
Assign Rank1 and Rank2
Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.
Detect Overlapping Tasks
Challenge No. 685: List the tasks which are overlapping.
Solved using: Python in Excel.
Split And Align Columns
Challenge No. 681: Split and align the data as shown.
Solved using: Python in Excel.
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.
Percentage Share Per Group
Challenge No. 654: Work out the % Revenue share of each year within a group where % = Revenue / Sum of Revenue of a Group.
Solved using: Python in Excel.
Running Total With Reset
Challenge No. 649: Calculate the running total for each group.
Solved using: Python.