Challenge No. 217: Transpose the table as shown by showing the amount paid each month.
Solved using: Python in Excel.
List.Transform
Applies a function to each element in a list in Power Query.
Show Transposed Amount Values
Challenge No. 216: Transpose the table as shown.
Solved using: Excel VBA.
Matrix Merge With Totals
Challenge No. 213: Merge the 2 tables and pivot them on Item with Total Row and Total Column.
Solved using: Python in Excel.
Subset Sum to Target
Challenge No. 488: This problem is contributed by Mehmet Çiçek
Find the numbers from column A which add up to the total given in column B.
Solved using: Python in Excel.
Max Frequency Characters
Challenge No. 487: Find the characters whose frequency is the maximum and also find the maximum frequency.
Solved using: Excel VBA.
Convert List to Integer Intervals
Challenge No. 486: Generate the integer intervals corresponding to given numbers.
Solved using: Python in Excel.
Group by Income Then Sort
Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
Solved using: R.
Summarize Yearly Sales
Challenge No. 207: Generate the result table from problem table.
Solved using: Python in Excel.
Compile Role Based Totals
Challenge No. 206: Generate the result table from problem table.
Solved using: Python in Excel.
Count Column Cross Matches
Challenge No. 204: For a column, find how many members of the column are contained in other columns.
Solved using: Python.