Challenge No. 103: Transpose the problem table into result table.
Solved using: Power Query (Table.SelectRows).
Pair and Sort People
Challenge No. 288: Make groups of 2 persons each in sequence and sort them.
Solved using: Python in Excel.
Fill Down using dynamic arrays.
Challenge No. 47: Add the opening stock to each recorded stock during the day
Note that this is not a running total but a stock adjustment
For example, the last recording on the 10th is 201, i.
Solved using: Python in Excel.
Maximize Buy-Sell Profit Days
Challenge No. 287: You will need to buy first and sell later.
Solved using: Python in Excel.
Performance!
Challenge No. 172: In this challenge, 250,000 rows of hourly historical data are provided, which are not sorted in any specific order.
Solved using:Excel (DROP, LET, SORT), Google Sheets, Power Query (Table.AddColumn, Table.Sort), Python, Python in Excel, and R.
Unique Dept-Name Combinations
Challenge No. 102: Prepare unique combinations of Dept and corresponding names.
Solved using: Power Query (List.Transform).
List all Right Truncatable Primes
Challenge No. 286: List all Right Truncatable Primes.
Solved using: Python 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.
Code State-Branch Combinations
Challenge No. 101: Create codes for the combination of State and Branch.
Solved using: Power Query.