Challenge No. 102: Prepare unique combinations of Dept and corresponding names.
Solved using: Power Query (List.Transform).
VSTACK
Stacks arrays vertically into a single column in Excel.
Generate Demlo Numbers diamond
Challenge No. 285: Generate Demlo Numbers diamond.
Solved using: R.
Table Transformation! Part 20
Challenge No. 171: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform), Python, Python in Excel, and R.
Teams With No Losses
Challenge No. 280: List the Teams which have never lost even a single game.
Solved using: Python in Excel.
Data Extraction
Challenge No. 45: Extract the Date and Amount from the details
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solutions.
Solved using: Python.
List Year of Maximum Values
Challenge No. 93: List the Maximum Amount and the Years in which these maximum amounts occurred.
Solved using: Python in Excel.
Custom Grouping! Part 12
Challenge No. 163: Convert the monthly sales data from the Question table into seasonal sales as shown in the Result table.
Solved using:Excel (FILTER, GROUPBY, HSTACK), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Extract From Text! Part 5
Challenge No. 162: Separate the values inside the curly braces { }, do the same for nested curly braces.
Solved using:Excel (IFNA, LAMBDA, LET), Google Sheets, Power Query (List.Transform, Table.AddColumn), Python, Python in Excel, R, and VBA.
Mark Repeats in Date Column
Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
Find Isogram Calendar Dates
Challenge No. 265: An Isogram date is a two digits year date in which no digit occurs more than once.
Solved using: Power Query.