Challenge No. 606: Merge rows on the basis of names.
Solved using: Python.
List.Sort
Sorts a list in ascending or descending order in Power Query.
Assign Fruits to Tiers
Challenge No. 566: Populate Fruits1, Fruits2 and Fruits3 against fruits beneath the counts.
Solved using: Python.
Sort Only Numeric Columns
Challenge No. 564: Sort the columns where only numbers will be sorted and non-numbers will not be sorted.
Solved using: R.
Sum and Sort Student Marks
Challenge No. 244: Merge both problem tables into one by summing marks for common entries.
Solved using: Python.
Spread Yearly Rows to Columns
Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Find unique number pairs
Challenge No. 336: Find the unique pair of numbers.
Solved using: Python in Excel.
Group Words by Anagrams
Challenge No. 282: An anagram is a word which is made by arranging the letters of another word.
Solved using: Python in Excel.
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.