Challenge No. 230: Summarize the table as shown by summing up Sales against each month.
Solved using: Python in Excel.
Table.Group
Groups rows in a table based on specified columns and applies aggregations in Power Query.
Shift Rows into Columns
Challenge No. 225: Transpose the problem table into result table.
Solved using: Python.
Distribute Activities by Month
Challenge No. 220: This challenge is contributed by Ahmad Syawal Ramli
Align the activities month-wise for each project.
Solved using: Python in Excel.
Mark Completed Tasks Only
Challenge No. 218: Transpose the table as shown.
Solved using: Python in Excel.
Salesperson Commission Breakdown
Challenge No. 212: Find the total commission of each sales person and sort it descending on total amount.
Solved using: Python.
Summarize Yearly Sales
Challenge No. 207: Generate the result table from problem table.
Solved using: Python in Excel.
Rank by Demand
Challenge No. 64: Rank the Fruits Based on Demand
e.
Solved using: Python.
Monthly Running Max Total
Challenge No. 198: Find the running total on the basis of max value for the month.
Solved using: Python.
Group Per Month
Challenge No. 60: Group the customers per month.
Solved using: Python.
Shared Item Billing Per Supplier
Challenge No. 195: Find the total amounts paid by all Stockists for the items purchased by them.
Solved using: R.