Challenge No. 238: Stepping Number is that number where adjacent digits have the difference of 1 or -1.
Solved using: Python in Excel.
⭐️⭐️⭐️⭐️ Advanced
Complex challenges for experienced users.
Create Simple Result Table
Challenge No. 76: Generate the result table from problem table.
Solved using: Power Query.
Transpose Departments into Row
Challenge No. 72: Transpose the data in a single row for all departments.
Solved using: Power Query (List.Transform).
Cap and Carry Running Totals
Challenge No. 71: Find the running total for the groups.
Solved using: Python in Excel.
Count Head Streaks by Alpha
Challenge No. 70: List those alphas which have consecutive streaks of H (H – Head, T – Tail)
List the count of consecutive occurrences in their respective columns sorted.
Solved using: Power Query.
Custom Grouping! Part 8
Challenge No. 139: The stock prices for the given dates are provided in the table.
Solved using:Excel (VSTACK), Google Sheets, Power Query (Table.Group, List.Combine, List.Transform), Python, and Python in Excel.
Classify Items as Used or New
Challenge No. 60: Generate the Result table from Problem table.
Solved using: Power Query (Table.AddColumn, Table.Split, Table.SplitColumn).
Mark Unique or Not Unique
Challenge No. 56: Populate Unique and Not Unique for different fruits against each garden depending upon its count.
Solved using: Power Query (List.Distinct, Table.Group, Table.TransformColumns).
Distribute Values by Mapping
Challenge No. 53: The relationship between Table T1 and Table T2 is given.
Solved using: Power Query.
Cartesian Product!
Challenge No. 128: Write all the 3 character words by using “A”,”B”,C”, AND “D”.
Solved using:Excel (LAMBDA, LET, REDUCE), Google Sheets, Power Query (List.Transform, List.TransformMany), Python, Python in Excel, and R.