Applies a function to each element in a list in Power Query.
Challenge No. 335: This is a 5 x 76 transposition cipher, where you start with the letter in the final position (‘W’) and then repeatedly step back through the whole ciphertext 5 positions at a time time, and then repeat that same process but starting from the letter one before the last position (‘T’) etc, revealing the first words of Geoffrey Chaucer’s ‘Canterbury Tales’.
Solved using: Python in Excel.
Challenge No. 333: Extract the string before any alphabet is repeated.
Solved using: R.
Challenge No. 196: Split the ID into two columns:
The first column should contain all letters.
Solved using:Excel (CONCAT, HSTACK, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Select, Table.AddColumn), Python, Python in Excel, and R.
Challenge No. 331: List those numbers which can be expressed as the sum of cube of two numbers.
Solved using: Python in Excel.
Challenge No. 195: In the ID column, the text should follow the format XX/XX/XX/XX (with a ‘/’ after every two characters).
Solved using:Excel (IF, LAMBDA, LEN), Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Challenge No. 330: Extract all the words which are greater than average length of the words in that sentence.
Solved using: R.
Challenge No. 194: For each date, samples are evaluated based on quality and marked with a “+” sign if they are within range and a “-” sign if they are out of range.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Remove, Text.Split), Python, Python in Excel, and R.
Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
Challenge No. 122: Transform the problem table into result table and work out the total number of hours a vehicle has run on a particular date.
Solved using: Power Query (List.Transform).
Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
