Challenge No. 51: Distribute the amount over month-year for every item.
Solved using: Power Query (List.Transform).
⭐️⭐️⭐️⭐️ Advanced
Complex challenges for experienced users.
Create Date Range Based on Rules
Challenge No. 46: Generate the result table as shown.
Solved using: SQL.
Generate Unique Records Based on Rules
Challenge No. 45: Calculate Running Total for each dealer.
Solved using: SQL.
Payments Duration!
Challenge No. 120: In challenge 60, we attempted to calculate the source of payment for each receipt.
Solved using:Excel, Google Sheets, Power Query (List.Transform), Python in Excel, and R.
Find Customer Stats With Conditions
Challenge No. 44: Generate result table as shown.
Solved using: Python in Excel.
Custom Grouping! Part 4
Challenge No. 119: The stock prices for the given dates are provided in the table.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python in Excel, and R.
Generate result table from the
Challenge No. 40: Generate the result table from the problem table as shown.
Solved using: Python.
Create the triangle on input
Challenge No. 38: Create the triangle on the basis of given input.
Solved using: Python.
List families by common last
Challenge No. 37: Create the list of Families and their members from the given names.
Solved using: SQL.
Match employee names using wildcard
Challenge No. 36: There are two tables.
Solved using: SQL.