Challenge No. 196: Transpose the problem table into result table.
Solved using: Python in Excel.
List.Distinct
Returns a list with duplicate values removed in Power Query.
Yearly Sales for All Continents
Challenge No. 187: Generate the result table from problem table.
Solved using: Python in Excel.
Reverse Data Splitting Problem
Challenge No. 182: Let’s do reverse of yesterday’s problem.
Solved using: Python.
Transpose Problem Table Format
Challenge No. 158: Transpose the Problem table into Result table.
Solved using: R.
Assign Teachers to Students
Challenge No. 156: Last Sunday’s challenge was deemed to be super-difficult.
Solved using: Python.
Summarize Hours by Role Title
Challenge No. 112: Generate the result table from problem table where Hours are summation for a particular role.
Solved using: Python in Excel.
Custom Grouping! Part 13
Challenge No. 165: Based on monthly transactions, categorize each customer for each month into one of the following groups:
New: A customer who has never made a purchase in previous months.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (Table.Group, List.Difference, List.Distinct), Python, and R.
Extract Results From Input
Challenge No. 85: Generate the result table from problem table.
Solved using: Python in Excel.
Transpose to Desired Table Format
Challenge No. 84: Transpose the problem table into result table.
Solved using: Excel VBA.
Calculate Percentage of Correct Answers
Challenge No. 83: Generate result table where Y means that right answer has been chosen and N means wrong answer has been chosen.
Solved using: Power Query (List.Distinct, Table.AddColumn).