Challenge No. 238: Stepping Number is that number where adjacent digits have the difference of 1 or -1.
Solved using: Python in Excel.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Unique Names with Sequence
Challenge No. 237: Prepare the result table from Problem table.
Solved using: Power Query.
Table Transformation! Part 16
Challenge No. 147: Transform the question structure into the result structure.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Skip, List.Split, Table.AddColumn), Python, Python in Excel, R, and VBA.
Sum Groups Separated by Blanks
Challenge No. 75: Groups are separated by blank rows in Problem table.
Solved using: Python in Excel.
Multiply Columns by Factor Dynamically
Challenge No. 73: Multiply Alpha, Beta, Gamma columns with Factor column.
Solved using: Python in Excel.
Transpose Departments into Row
Challenge No. 72: Transpose the data in a single row for all departments.
Solved using: Power Query (List.Transform).
Find Kangaroo and Joey Words
Challenge No. 225: Kangaroo words are those words which contain the other words within themselves.
Solved using: Excel VBA.
Sort Rows by Key Count
Challenge No. 223: Sort the rows in columns A through H as per Sort key.
Solved using: Power Query.
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.
Table Transformation! Part 15
Challenge No. 142: The Question table contains information about the fingerprinting times for various personnel when entering the company.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.AddColumn, Table.Group, Table.Pivot), Python, Python in Excel, and R.