Challenge No. 340: From dataset in column A, create the table under Answer Expected.
Solved using: Python in Excel.
By Topic
Challenges categorized by topic.
Column Combining! Part 2
Challenge No. 199: Given multiple columns, concatenate them based on the order presented on the pattern column using space as a delimiter.
Solved using:Excel (BYROW, CHOOSECOLS, DROP), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Calculate check digit using Damm algorithm
Challenge No. 338: Calculate check digit using Damm algorithm.
Solved using: Python in Excel.
Text Mapping Between Tables
Challenge No. 130: For Table T2, look for value column of Table T1 in City/Country and Text columns of Table T2 and prepare the mapping shown in Result table.
Solved using: DAX.
Matrix Calculation! Part 2
Challenge No. 198: Create a formula that, for any ‘n x n’ matrix, calculates z1 to zn, where zi is the sum of all the values in the ith row and the ith column of the matrix.
Solved using:Excel (BYCOL, INDEX, LAMBDA), Google Sheets, Power Query (List.Transform, Table.FromRows, Table.ToColumns), Python, Python in Excel, and R.
Mark Min/Max Date From Today
Challenge No. 129: Generate the result shown above.
Solved using: DAX.
Decrypt using 5×76 transposition cipher
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.
Custom Grouping! Part 19
Challenge No. 197: Group the rows sequentially from the top, ensuring that each group contains exactly one missing date.
Solved using:Excel (IF, LET, SCAN), Google Sheets, Power Query (Table.Group, Table.AddIndexColumn), Python, Python in Excel, and R.
Column Splitting! Part 6
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.
Get Zodiac from Date Range
Challenge No. 127: Find out the Zodiac signs for table T1 from Table T2.
Solved using: DAX.