Challenge No. 202: Transpose the problem table into result table.
Solved using: R.
List.Transform
Applies a function to each element in a list in Power Query.
Fill Missing Cells with Max
Challenge No. 462: Fill in the blanks with max from the immediate surrounding cells.
Solved using: Python in Excel.
Custom String Sorting
Challenge No. 461: Sort the given strings as given in the answer.
Solved using: Python.
Identify Anti-Perfect Numbers
Challenge No. 455: Anti perfect number is that number where number is equal to sum of reverse of its perfect divisors’ digits.
Solved using: Python in Excel.
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.
Max Consecutive Number Streak
Challenge No. 451: Find the positive and negative numbers which occur consecutively maximum number of times.
Solved using: Python in Excel.
Reverse Cumulative Row Sums
Challenge No. 194: The cumulative sum across rows is given in problem table.
Solved using: Python in Excel.
Group and Sum
Challenge No. 59: Group and Sum Shop Fruit Sales
e.
Solved using: R.
Unstack Groups for Summation
Challenge No. 193: Transpose the problem table into result table.
Solved using: Python in Excel.
Find Penholodigital Squares
Challenge No. 447: Penholodigital squares are perfect square numbers that contain digits from 1 to 9 exactly once.
Solved using: R.