Challenge No. 187: Generate the result table from problem table.
Solved using: Python in Excel.
Table.Sort
Sorts a table by specified columns in ascending or descending order in Power Query.
Pivot Using Suffix Headers
Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Top 3 marks with names and subjects
Challenge No. 327: List the top 3 marks and names and subjects against them.
Solved using: Python in Excel.
Table Transformation! Part 24
Challenge No. 192: Any row with a negative quantity should reduce the corresponding value in the previous rows for the related product.
Solved using:Excel (DROP, FILTER, LAMBDA), Google Sheets, Power Query (Table.Group, Table.SelectRows, Table.Sort), Python, Python in Excel, and R.
Find Entry-Exit Exceptions
Challenge No. 109: For every entry, there has to be an exit which should come after entry.
Solved using: Excel VBA.
Performance!
Challenge No. 172: In this challenge, 250,000 rows of hourly historical data are provided, which are not sorted in any specific order.
Solved using:Excel (DROP, LET, SORT), Google Sheets, Power Query (Table.AddColumn, Table.Sort), Python, Python in Excel, and R.
Filter Last Transaction!
Challenge No. 158: From the question table, extract the last transaction per product for each month.
Solved using:Excel (DROP, FILTER, GROUPBY), Google Sheets, Power Query (Date.Month, Table.AddColumn, Table.Combine), Python, Python in Excel, and R.
Show Unique Assignee Priorities
Challenge No. 82: Generate the result table from problem table where Assignee and Priority are one below the other.
Solved using: Python in Excel.
Sum Values by Letter Codes
Challenge No. 77: Generate the result table from problem table.
Solved using: Python in Excel.
List Unique Assignee Priorities
Challenge No. 65: Generate the result table from problem table where Assignee and Priority are one below the other.
Solved using: Power Query (Table.Distinct, Table.Sort).