Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
Table.ColumnNames
Returns a list of column names from a table in Power Query.
Prepare the result table from
Challenge No. 252: Prepare the result table from problem table.
Solved using: Python.
Sum and Sort Student Marks
Challenge No. 244: Merge both problem tables into one by summing marks for common entries.
Solved using: Python.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Reshape Wide Table Format
Challenge No. 224: Transpose the problem table into result table.
Solved using: Python.
Calculate Monthly Payments
Challenge No. 217: Transpose the table as shown by showing the amount paid each month.
Solved using: Python in Excel.
Summarize Yearly Sales
Challenge No. 207: Generate the result table from problem table.
Solved using: Python in Excel.
Reverse Cumulative Row Sums
Challenge No. 194: The cumulative sum across rows is given in problem table.
Solved using: Python in Excel.
Yearly Sales for All Continents
Challenge No. 187: Generate the result table from problem table.
Solved using: Python in Excel.
Transform Input to Result Table
Challenge No. 181: Generate the result table from problem table.
Solved using: Python.