Challenge No. 278: Reduce the number to a single digit number by repeatedly subtracting the adjacent digits.
Solved using: Python in Excel.
List.Transform
Applies a function to each element in a list in Power Query.
Find Max Substring from Length
Challenge No. 271: Cut all substrings from column A of length given in column B and find the max.
Solved using: Python in Excel.
Decrypt Baconian Cipher Text
Challenge No. 268: Find the Decrypted words corresponding to Encrypted words .
Solved using: Excel VBA.
Extract From Text! Part 5
Challenge No. 162: Separate the values inside the curly braces { }, do the same for nested curly braces.
Solved using:Excel (IFNA, LAMBDA, LET), Google Sheets, Power Query (List.Transform, Table.AddColumn), Python, Python in Excel, R, and VBA.
Odd Even Min Max Split
Challenge No. 263: Separate out odd and even numbers and give their min and max separated by dash.
Solved using: SQL.
Table Transformation! Part 18
Challenge No. 157: Transform the question structure into the result structure.
Solved using:Excel (HSTACK, INDEX, LAMBDA), Google Sheets, Power Query (List.Split, List.Transform, Text.Split), Python, Python in Excel, and R.
Column Splitting! Part 3
Challenge No. 156: If the IDs contain an even number of characters, split them into two columns at the midpoint.
Solved using:Excel (HSTACK, IF, IFNA), Google Sheets, Power Query (List.Transform, Text.End, Text.Start), Python, Python in Excel, and R.
Table Transformation! Part 17
Challenge No. 155: Transform the question table into the result table format.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Skip, List.Transform, Table.AddColumn), Python, Python in Excel, and R.
Identify Diamond Strings
Challenge No. 245: List all Diamond strings from column A.
Solved using: R.
Eight Queens Puzzle!
Challenge No. 150: Theeight-queenss puzzle is the problem of placing eight chess queens on an 8×8 chessboard so that no two queens threaten each other; thus, a solution requires that no two queens share the same row, column, or diagonal.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Combine, List.Transform), and Python in Excel.