Challenge No. 694: Repeat every character in the string except those characters which appear consecutively.
Solved using: R.
Text.Combine
Concatenates a list of text values using a specified delimiter in Power Query.
Align Names With Amounts
Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.
Bottom Three Unique Values
Challenge No. 650: List the bottom 3 unique values across the columns.
Solved using: Python.
Swap Number Sequences
Challenge No. 643: Replace next set of numbers with previous set of numbers and first set of numbers will be replaced by last set of numbers.
Solved using: Python in Excel.
Merge and Sort Name Rows
Challenge No. 606: Merge rows on the basis of names.
Solved using: Python.
Transpose table, summing values from
Challenge No. 275: Transpose the problem table into result table where value is sum of Values from problem table.
Solved using: Python.
Check ingredient availability for dishes
Challenge No. 274: Problem Table1 contains the list of ingredients which can be used to prepare a dish.
Solved using: Python.
Missing Letters and Frequencies
Challenge No. 589: From the list of longest words in English, list the missing alphabets from English language and also the alphabet whose frequency is the highest (in sorted order).
Solved using: Python in Excel.
Transpose problem table into result
Challenge No. 249: Transpose problem table into result table.
Solved using: Python.
For each Deal, list the
Challenge No. 246: For each Deal, list the name of the persons who handled the deal most recently.
Solved using: Python.