Challenge No. 216: Transpose the table as shown.
Solved using: Excel VBA.
List.RemoveNull
Removes null values from a list in Power Query.
Reverse Cities Columns
Challenge No. 159: Reverse all columns from Cities1 to Cities5.
Solved using: Power Query (List.RemoveNull, List.Reverse, List.Transform).
Generate Cartesian product of values
Challenge No. 34: Generate the Cartesian product as shown.
Solved using: SQL.
Last Inventory Level!
Challenge No. 95: In the Question table, monthly inventory levels of products are provided.
Solved using:Excel (BYROW, FILTER, HSTACK), Google Sheets, Power Query (List.RemoveNull, Table.AddColumn, Table.Group), Python, Python in Excel, and R.