Challenge No. 187: Group the rows until encountering a missing date.
Solved using:Excel (DROP, GROUPBY, IF), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Table.AddColumn
Adds a new column to a table with computed values in Power Query.
Column Splitting! Part 4
Challenge No. 186: Split the ID into two columns:
The first column should contain all vowels (A, E, I, O, U).
Solved using:Excel (BYROW, CONCAT, HSTACK), Google Sheets, Power Query (Text.Combine, Text.Remove, Text.Select), Python, Python in Excel, and R.
Divide Payment Across Quarters
Challenge No. 117: Equally divide the payment over current quarter and next 3 quarters.
Solved using: Python in Excel.
Resetting Running Totals
Challenge No. 51: Calculate running totals for defective free units
Running Total resets to ZERO with each defection noted
For example, on the 14th, the running total is 214 since we have defects on the 13th
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
Evaluate Reverse Polish Notation
Challenge No. 297: Simplified version of Reverse Polish Notation (RPN) – The math operator will come at the end of the Text and you need to evaluate the expression.
Solved using: Python in Excel.
Table Transformation! Part 21
Challenge No. 177: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group), Python, Python in Excel, and R.
Performance!
Challenge No. 172: In this challenge, 250,000 rows of hourly historical data are provided, which are not sorted in any specific order.
Solved using:Excel (DROP, LET, SORT), Google Sheets, Power Query (Table.AddColumn, Table.Sort), Python, Python in Excel, and R.
Calculate Quarterly Working Payment
Challenge No. 100: Per day rates for every person for a duration is given.
Solved using: Python in Excel.
Extract From Text! Part 7
Challenge No. 169: Similar to Challenge 149, extract the texts between the pairs of the characters listed below.
Solved using:Excel (ARRAYTOTEXT, LAMBDA, MAP), Google Sheets, Power Query (List.Split, List.Transform, Text.Combine), Python, Python in Excel, and R.
Process Time Running Totals
Challenge No. 98: 1.
Solved using: Python.