Challenge No. 670: Transpose the table as shown.
Solved using: Python.
List.Distinct
Returns a list with duplicate values removed in Power Query.
Count Unique Uncommon Words
Challenge No. 610: Find the number of un-common unique words between Sentence1 and Sentence2.
Solved using: Python.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
Assign Fruits to Tiers
Challenge No. 566: Populate Fruits1, Fruits2 and Fruits3 against fruits beneath the counts.
Solved using: Python.
Transpose the problem table into
Challenge No. 248: Transpose the problem table into result table.
Solved using: Python.
Prepare the result table on
Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.
Spread Yearly Rows to Columns
Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.
Pair Swipes
Challenge No. 73: Pair the staff Swipes.
Solved using: R.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Distribute Activities by Month
Challenge No. 220: This challenge is contributed by Ahmad Syawal Ramli
Align the activities month-wise for each project.
Solved using: Python in Excel.