Challenge No. 179: Generate the result table from problem table.
Solved using: R.
List.Transform
Applies a function to each element in a list in Power Query.
Split and Running Total Rows
Challenge No. 176: Generate the result table from problem table.
Solved using: Python in Excel.
Monthly Sales Split Calendar Days
Challenge No. 174: For all employees, insert the rows for each month and divide the Sales amount over these months as per number of calendars days in the month.
Solved using: R.
Pivot Using Suffix Headers
Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Square Digits Until Single Number
Challenge No. 412: Square the individual digits of a number and sum them.
Solved using: Python in Excel.
Calculate Agent Commission Totals
Challenge No. 172: Find the total commission paid to each agent along with a Grand Total row.
Solved using: R.
Summarize by Five-Year Brackets
Challenge No. 403: Generate the Sum of Value and % of Value for year brackets of 5 years each.
Solved using: Python in Excel.
Check Connectivity of Random Points
Challenge No. 400: Coordinates for points are given in x, y format.
Solved using: R.
Encrypt Words with Tri Numeral Cipher
Challenge No. 397: Tri Numeral Alphabet Cipher – English alphabets are divided into groups containing 3 alphabets each and last group contain only 2 alphabets i.
Solved using: Python in Excel.
Distance Matrix Between Cities
Challenge No. 160: x, y coordinates are given for different cities.
Solved using: Python in Excel.