Challenge No. 192: Convert the problem table into result table.
Solved using: Python.
List.Transform
Applies a function to each element in a list in Power Query.
Extract Valid Structured Words
Challenge No. 191: Extract the words which are either numbers followed by all uppercase English letters or vice versa.
Solved using: Python in Excel.
Split Data by Capital Letters
Challenge No. 190: Split the data into columns.
Solved using: R.
Generate Integers From Ranges
Challenge No. 441: Generate the integers corresponding to intervals.
Solved using: Python.
Allocate Amounts by Quarter Days
Challenge No. 188: Divide the amount across quarters falling in between From and To Date.
Solved using: Python in Excel.
Yearly Sales for All Continents
Challenge No. 187: Generate the result table from problem table.
Solved using: Python in Excel.
Encrypt Using Bifid Cipher
Challenge No. 437: Bifid Cipher with Keyword
Suppose we want to encrypt the message “BATTLE” and keyword is “ROTORS”.
Solved using: Python in Excel.
List Prime Pandigital Numbers
Challenge No. 436: An n digit number is Pandigital if it makes use of all the digits 1 to n exactly once.
Solved using: Excel VBA.
Encrypt with Bifid Cipher Method
Challenge No. 432: Bifid Cipher
Suppose we want to encrypt the message “BATTLE”.
Solved using: Python in Excel.
Quarterly Hike Compounding Table
Challenge No. 183: Transpose the problem table into result table.
Solved using: Python in Excel.