Challenge No. 207: Generate the result table from problem table.
Solved using: Python in Excel.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Pivot Yes No Percentages
Challenge No. 205: From tables T1 and T2, generate the result table.
Solved using: Python in Excel.
Average Between Blank Groups
Challenge No. 203: Prepare the groups which lie between two blank Amount1s and give the average of numbers appearing in those groups (groups shaded in light red).
Solved using: R.
Rank by Demand
Challenge No. 64: Rank the Fruits Based on Demand
e.
Solved using: Python.
Mark Overlapping Time Ranges
Challenge No. 467: If tasks’ From Time and To Time overlap with each other, mark them as Y.
Solved using: Python in Excel.
Transpose Vertical to Horizontal
Challenge No. 202: Transpose the problem table into result table.
Solved using: R.
Map Buyer Purchase Dates
Challenge No. 201: List what items each of the buyers bought? Table2 is for availability dates of the items during which items could have been bought.
Solved using: Python in Excel.
Calculate Monthly Inventories
Challenge No. 463: Calculate the inventory at the end of all months of the year.
Solved using: Python in Excel.
Merge Subject Maximum Marks
Challenge No. 200: Merge the two tables by taking maximum marks of the subject.
Solved using: Python in Excel.
Monthly Running Max Total
Challenge No. 198: Find the running total on the basis of max value for the month.
Solved using: Python.