Challenge No. 515: Normalize the data given in columns A to B as given in Answer Expected.
Solved using: Python.
Table.ExpandListColumn
Expands a list column into multiple rows in Power Query.
Generate Cartesian product of values
Challenge No. 34: Generate the Cartesian product as shown.
Solved using: SQL.
Table Transformation! Part 8
Challenge No. 65: In the question table, the total costs for different date ranges are provided.
Solved using:Excel (HSTACK, LAMBDA, LET), Power Query (List.Dates, List.Transform, Table.AddColumn), Python, R, and VBA.