Challenge No. 244: Merge both problem tables into one by summing marks for common entries.
Solved using: Python.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Unstack Columns to Rows
Challenge No. 243: Transform the problem table into result table as shown.
Solved using: Python.
Fill 5×5 Grid with Index
Challenge No. 536: Put values in a 5×5 grid as per their rows and columns positions.
Solved using: R.
Reformat Item Entries
Challenge No. 242: Transform the problem table into result table as shown.
Solved using: Python.
Spread Yearly Rows to Columns
Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.
Remove Digit to Make Divisible
Challenge No. 531: List first 500 numbers starting with 101 which don’t end with 0 and are divisible at least once by removing one digit at a time from the number.
Solved using: R.
Max Sale Date and Amount
Challenge No. 530: Find the dates when maximum sales was made for a person and also list the corresponding amount.
Solved using: Python.
Rank Sales Drop Per Person
Challenge No. 239: Transpose the problem table into result table and calculate the drop in sales amount from one quarter to previous quarter.
Solved using: Python.
Split Periods For The Project
Challenge No. 74: Create Weekly Date Groups and Sum
A Week runs from Monday to Sunday
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Align Nested Headers
Challenge No. 236: Transpose the data as shown.
Solved using: Python in Excel.