Challenge No. 136: Split the ID values where a character is repeated consecutively.
Solved using:Excel (CONCAT, DROP, IF), Google Sheets, Power Query (List.Transform, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Text.Combine
Concatenates a list of text values using a specified delimiter in Power Query.
Identify The Pattern !
Challenge No. 135: Find the number of occurrences of the “+-+” pattern across the test IDs for each product.
Solved using:Excel (BYROW, CONCAT, DROP), Google Sheets, Power Query (List.Range, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Reverse Long Words
Challenge No. 161: If a word in sentence has length > Number, then reverse that word.
Solved using: Power Query (Text.Combine).
Return Repeat Customers
Challenge No. 37: Return only dates with repeat customers and repeated customers Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Generate result table from the
Challenge No. 40: Generate the result table from the problem table as shown.
Solved using: Python.
Match employee names using wildcard
Challenge No. 36: There are two tables.
Solved using: SQL.
Sort by Type and Case
Challenge No. 116: Sort the strings within the cells.
Solved using: SQL.
Lookup Unique Set of Duplicates
Challenge No. 27: Extract Products with a Unique Set of 3 Customers in the whole dataset
For Example, Product A & D has a duplicate set of the 3 customers Dynamic array function allowed but Extra marks for Legacy solutions
or PowerQuery Solution.
Solved using: Python in Excel.
Find Non-Common Words
Challenge No. 112: Find the words which are not common between Group 1 and Group 2.
Solved using: SQL.
Numbers with Odd Frequencies
Challenge No. 89: List the numbers which occur odd number of times.
Solved using: Python.