Challenge No. 140: List the common letters between Word1 and Word2 and sort them alphabetically.
Solved using: Power Query (List.Distinct, Table.AddColumn).
Table.AddColumn
Adds a new column to a table with computed values in Power Query.
Split and Pivot Data
Challenge No. 34: Split and pivot the Orders table
For example, Fred has only 2 Orders on the 14th and 15th Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Unique Letters Per Word
Challenge No. 137: List those strings whose words contain only unique letters.
Solved using: Power Query (Table.AddColumn).
Merge! Part 1
Challenge No. 114: In Question Table 1, the dates and product IDs are provided.
Solved using:Excel (FILTER, HSTACK, IFERROR), Google Sheets, Power Query (Text.Split, Table.AddColumn), Python, Python in Excel, R, and SQL.
Add Suffix to Duplicates
Challenge No. 134: If an animal appears more than once, then that animal’s name should be suffixed with 1, 2, 3.
Solved using: SQL.
List families by common last
Challenge No. 37: Create the list of Families and their members from the given names.
Solved using: SQL.
Duplicate Values! Part 2
Challenge No. 113: Consider the IDs in the question table.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Extract Complete Months
Challenge No. 32: Calculate the number of complete Months per Year per Project
For example, Proj A starts in 2022 (for 10 months), 2023(12 months), Ends 2024(6 months)
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Insert blank rows based on
Challenge No. 35: Insert the number of blank rows after the records as per Number column.
Solved using: Python.
Generate Cartesian product of values
Challenge No. 34: Generate the Cartesian product as shown.
Solved using: SQL.