Challenge No. 24: Generate the result table.
Solved using: Power Query (List.Distinct).
List.Distinct
Returns a list with duplicate values removed in Power Query.
Match Output to Picture
Challenge No. 83: Generate the output as shown in picture.
Solved using: SQL.
Top 4 Winner and Runner-up
Challenge No. 78: — This week will be FIFA World Cup week.
Solved using: SQL.
Dynamic Table Generation Result
Challenge No. 16: (Excel formulas also welcome)
Generate the Result table shown.
Solved using: Power Query (List.Distinct, Table.Pivot, Table.PromoteHeaders).
Flexible Result Table Creation
Challenge No. 11: (Excel formulas also welcome)
Generate Result table as shown.
Solved using: Power Query (List.Distinct, Table.AddColumn, Table.Pivot).
Generate result table from Alphabets
Challenge No. 3: (Excel formulas also welcome)
Generate the result table from Alphabets table.
Solved using: Power Query (List.Distinct).
Determining Missing Fields
Challenge No. 74: Customer information including Name, Family, Phone, and Website is provided in the question table.
Solved using:Excel (ARRAYTOTEXT, FILTER, HSTACK), Power Query (List.Difference, List.Distinct, Text.Combine), Python, and R.
Merged Cells!
Challenge No. 66: Convert the Question table with the merge headers into the result table.
Solved using:Excel (DROP, HSTACK, IF), Power Query (List.Distinct, List.PositionOf, Table.Pivot), Python, R, and VBA.
Merge Columns
Challenge No. 59: The power consumption of a house every 30 minutes on different dates is provided in the question table.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Power Query (List.Distinct, List.Skip, List.Split), Python, Python in Excel, and R.
Warehouse Management!
Challenge No. 55: In the question table, transactions for different products are presented.
Solved using:Excel (FILTER, HSTACK, INDEX), Power Query (List.Distinct, Table.Group, Table.Pivot), Python, and R.