Challenge No. 233: Calculate the Shipped and Non-shipped amounts (Quantity * Price) for all Fruits.
Solved using: Python.
DROP
Removes a specified number of rows or columns from an array in Excel.
Repeat Rows Until Next Date
Challenge No. 232: Repeat a row till the next date.
Solved using: Python in Excel.
Align Rowwise Data
Challenge No. 520: Align the data as given in answer expected.
Solved using: Python in Excel.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Perfect Square Predecessor Checker
Challenge No. 517: Arrange the given numbers in such a fashion that sum of preceding + current number is a perfect square.
Solved using: Python in Excel.
Normalize Tabular Data
Challenge No. 515: Normalize the data given in columns A to B as given in Answer Expected.
Solved using: Python.
Reshape Wide Table Format
Challenge No. 224: Transpose the problem table into result table.
Solved using: Python.
List Subject Pass Students
Challenge No. 222: Marks for various tests are given in problem table.
Solved using: R.
Interleave Numbers into Letters
Challenge No. 506: Concat column B numbers into column 1 alphabets.
Solved using: Python.
Extract and Group
Challenge No. 70: Extract the Departments and their Sub-department
Department name is before the 1st hyphen
Solution should be in a Cross-tab as shown
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.