Challenge No. 225: Transpose the problem table into result table.
Solved using: Python.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Reshape Wide Table Format
Challenge No. 224: Transpose the problem table into result table.
Solved using: Python.
Subject Scores Transposition
Challenge No. 223: 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.
Hierarchical Project Indexing
Challenge No. 221: Do the Indexing for project, task and activity.
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.
Aggregate Customer Purchase Stats
Challenge No. 503: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Calculate the sum, average, maximum value, minimum value, count, and payment amount for products purchased by each customer.
Solved using: Python in Excel.
Distribute Activities by Month
Challenge No. 220: This challenge is contributed by Ahmad Syawal Ramli
Align the activities month-wise for each project.
Solved using: Python in Excel.
Extract Entries from Running Total
Challenge No. 500: Get the individual entries from the running total which is across the row and continues to the next rows.
Solved using: Python.