Challenge No. 237: Prepare the result table from Problem table.
Solved using: Power Query.
Table Transformation! Part 16
Challenge No. 147: Transform the question structure into the result structure.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Skip, List.Split, Table.AddColumn), Python, Python in Excel, R, and VBA.
Sum Groups Separated by Blanks
Challenge No. 75: Groups are separated by blank rows in Problem table.
Solved using: Python in Excel.
Incremental Caesar Cipher
Challenge No. 236: We had 3 challenges on Caesar’s Cipher (if you are unaware about Caesar’s Cipher, I will encourage you to visit previous challenge to get an idea)
This is a variation of Caesar’s Cipher.
Solved using: Power Query (List.Transform).
Group Text by Keyword
Challenge No. 235: Populate the Groups (from table 2) on the basis of words appearing in Text column.
Solved using: Power Query.
Column Splitting! Part 2
Challenge No. 146: Split the IDs from the beginning of the text up to the “|” character in each occurrence of “|”.
Solved using:Excel (IFNA, LAMBDA, LEN), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, R, and VBA.
Suffix Names with Duplicates
Challenge No. 74: For a given name, suffix the names with A, B, C.
Solved using: R.
Divisible by Each Digit
Challenge No. 234: Find the numbers which are divisible by their individual digits.
Solved using: Python in Excel.
Check Pandigital by Base
Challenge No. 231: List Yes if a Number is Pandigital number in a given base else No.
Solved using: Power Query.
Validate Multi-Word Names
Challenge No. 233: List all valid names from A2:A11
The criteria for valid names are –
1.
Solved using: Power Query.