Challenge No. 224: Transpose the problem table into result table.
Solved using: Python.
Table.RenameColumns
Renames one or more columns in a table in Power Query.
Transform Input to Result Table
Challenge No. 181: Generate the result table from problem table.
Solved using: Python.
Table Transformation! Part 21
Challenge No. 177: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group), Python, Python in Excel, and R.
Merged Cells!
Challenge No. 66: Convert the Question table with the merge headers into the result table.
Solved using:Excel (DROP, HSTACK, IF), Power Query (List.Distinct, List.PositionOf, Table.Pivot), Python, R, and VBA.