Splits a text string into a list based on a delimiter in Power Query.
Challenge No. 194: For each date, samples are evaluated based on quality and marked with a “+” sign if they are within range and a “-” sign if they are out of range.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Remove, Text.Split), Python, Python in Excel, and R.
Challenge No. 183: In the question table, the dates are provided in various formats.
Solved using:Excel (IFERROR, INDEX, LAMBDA), Google Sheets, Power Query (Text.Split, Table.Distinct, Table.TransformColumns), Python, Python in Excel, and R.
Challenge No. 110: Fill in the alphabets from Names column in Name1.
Solved using: Python in Excel.
Challenge No. 104: Prepare the result table from problem table.
Solved using: Python.
Challenge No. 263: Separate out odd and even numbers and give their min and max separated by dash.
Solved using: SQL.
Challenge No. 157: Transform the question structure into the result structure.
Solved using:Excel (HSTACK, INDEX, LAMBDA), Google Sheets, Power Query (List.Split, List.Transform, Text.Split), Python, Python in Excel, and R.
Challenge No. 146: Split the IDs from the beginning of the text up to the “|” character in each occurrence of “|”.
Solved using:Excel (IFNA, LAMBDA, LEN), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, R, and VBA.
Challenge No. 175: Find the common words between Sentence1 and Sentence 2 and sort the common words.
Solved using: Power Query (Text.Split).
Challenge No. 42: Count Stalls Stocking either Apple or Kiwi
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
Challenge No. 152: Remove the Words from column A as per index in column B.
Solved using: Excel VBA.
