Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.
Table.Pivot
Transforms a table by pivoting column values into new columns in Power Query.
For each Deal, list the
Challenge No. 246: For each Deal, list the name of the persons who handled the deal most recently.
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.
Calculate Shipped Fruit Value
Challenge No. 233: Calculate the Shipped and Non-shipped amounts (Quantity * Price) for all Fruits.
Solved using: Python.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Extract Results From Input
Challenge No. 85: Generate the result table from problem table.
Solved using: Python in Excel.
Table Transformation! Part 15
Challenge No. 142: The Question table contains information about the fingerprinting times for various personnel when entering the company.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.AddColumn, Table.Group, Table.Pivot), Python, Python in Excel, and R.
Periodic Sales Summary!
Challenge No. 138: Based on the “transactions” table, summarize the sales for each month by breaking them into three periods:
P1: First 10 days of the month
P2: From the 11th to the 20th
P3: From the 21st onward.
Solved using:Excel (DAY, DROP, HSTACK), Google Sheets, Power Query (Date.Month, List.Distinct, Table.AddColumn), Python, Python in Excel, and R.
Filter Values Based on Table
Challenge No. 61: Generate Result table on the basis of T1 and T2.
Solved using: Power Query (List.Distinct, Table.Group, Table.Pivot).
Find Customer Stats With Conditions
Challenge No. 44: Generate result table as shown.
Solved using: Python in Excel.