Challenge No. 476: Divide the Sales from Table1 into Table2 equally over Stores.
Solved using: Python.
Table.AddColumn
Adds a new column to a table with computed values in Power Query.
Pivot Yes No Percentages
Challenge No. 205: From tables T1 and T2, generate the result 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.
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.
Monthly Running Max Total
Challenge No. 198: Find the running total on the basis of max value for the month.
Solved using: Python.
Shared Item Billing Per Supplier
Challenge No. 195: Find the total amounts paid by all Stockists for the items purchased by them.
Solved using: R.
Schedule and Cost Performance
Challenge No. 192: Convert the problem table into result table.
Solved using: Python.
Yearly Sales for All Continents
Challenge No. 187: Generate the result table from problem table.
Solved using: Python in Excel.
Extract Ending Pattern Group
Challenge No. 184: Extract the last group of alphabets followed by numbers in each Text and concat them with a dash in between for each Set.
Solved using: Python.
Transform Input to Result Table
Challenge No. 181: Generate the result table from problem table.
Solved using: Python.