Challenge No. 239: Transpose the problem table into result table and calculate the drop in sales amount from one quarter to previous quarter.
Solved using: Python.
List.Zip
Merges multiple lists into a list of lists, pairing corresponding elements in Power Query.
Reverse Cumulative Row Sums
Challenge No. 194: The cumulative sum across rows is given in problem table.
Solved using: Python in Excel.
Perform Faro Shuffle Types
Challenge No. 369: Faro Shuffle – Divide the data in two equal parts (data will always be even, so two equal parts).
Solved using: DAX.
Column Combining! Part 1
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.
Vernam Cipher Encrypt
Challenge No. 162: Vernam Cipher (also known as One time pad cipher)
1.
Solved using: Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip).
Text Split!
Challenge No. 45: The “Question” table contains product IDs of varying lengths.
Solved using:Excel (LAMBDA, LET, MID), Power Query (List.Transform, List.Zip, Table.AddColumn), Python, R, and VBA.