Challenge No. 421: Stack the diagonals read from left to right of a matrix in rows.
Solved using: Python.
Track Org Role Changes
Challenge No. 178: Create a corresponding row in result table if there is a change in either role or org.
Solved using: R.
Decode Color Band Resistance
Challenge No. 420: For the given color bands in Column E, work out the total resistance.
Solved using: Python in Excel.
Find Reverse-Divisible Non-Palindromes
Challenge No. 419: Reverse a number.
Solved using: Python in Excel.
Split and Running Total Rows
Challenge No. 176: Generate the result table from problem table.
Solved using: Python in Excel.
Pivot for Time Entries by Date
Challenge No. 418: Pivot the given table for Date / Emp ID combinations with Min and Max Time.
Solved using: Python in Excel.
Split by Alpha-Numeric Change
Challenge No. 417: Split the given strings whenever a changeover happens between English alphabets and numbers.
Solved using: Excel VBA.
Family Relationship Tree View
Challenge No. 175: List the Names along with the Names of next generation and relationship between generations.
Solved using: Python.
Generate Number Outline Sequence
Challenge No. 416: Generate the number outlining.
Solved using: R.
Cyclops and Triangular Numbers
Challenge No. 415: A Cyclops number is a number that has a zero in the center (so, it needs to have odd number of digits and >=3 digits).
Solved using: Python in Excel.