Challenge No. 242: If Number1 and Number2 are primes and if difference between them is:
2 – Twin Prime
4 – Cousin Prime
6 – Sixy Prime
Categorize the Numbers given in column A and B.
Solved using: Power Query (List.Transform).
List.Transform
Applies a function to each element in a list in Power Query.
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).
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.
Create Snake Number Grid
Challenge No. 230: This challenge is contributed by Mehmet Çiçek.
Solved using: Excel VBA.
Length Of Pattern!
Challenge No. 145: Find the largest length of occurrences of the “++-” pattern across the test IDs for each product.
Solved using:Excel (CONCAT, GROUPBY, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Multiply Columns by Factor Dynamically
Challenge No. 73: Multiply Alpha, Beta, Gamma columns with Factor column.
Solved using: Python in Excel.
Transpose Departments into Row
Challenge No. 72: Transpose the data in a single row for all departments.
Solved using: Power Query (List.Transform).
Top Headers by Total
Challenge No. 220: First row is column headers and first column is row headers.
Solved using: Power Query (List.Transform).
Find Co-Prime Pairs
Challenge No. 214: Co-prime numbers are those numbers whose Highest Common Factor (Highest Common Divisor) is 1.
Solved using: Power Query (List.Transform).
Custom Grouping! Part 8
Challenge No. 139: The stock prices for the given dates are provided in the table.
Solved using:Excel (VSTACK), Google Sheets, Power Query (Table.Group, List.Combine, List.Transform), Python, and Python in Excel.