Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
Text.Split
Splits a text string into a list based on a delimiter 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.
Extract Zip and Country Info
Challenge No. 608: Extract zip code (5 or 6 digits in length) and country names.
Solved using: Python.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
Match Words in Column Data
Challenge No. 599: Look up the Words (in column D) in Column1 and list the Result from Column2.
Solved using: Python.
Transpose the table as shown
Challenge No. 273: Transpose the table as shown.
Solved using: Python.
Transpose the given data from
Challenge No. 261: Transpose the given data from Problem Table into Result table as shown.
Solved using: Python in Excel.
Unstack Columns to Rows
Challenge No. 243: Transform the problem table into result table as shown.
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.