Challenge No. 3: Extract all possible combinations of ID and result in the right-side table.
Solved using:Excel (BYROW, COUNTA, DROP), Power Query (List.Transform), Python, and Python in Excel.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Table Transformation! Part 1
Challenge No. 1: On various dates, the cumulative sales values (from the beginning of the year) for different products are presented (in the Question table).
Solved using:Excel (DROP, FILTER, HSTACK), and Power Query (Table.AddColumn, Table.TransformColumnTypes).