Challenge No. 421: Stack the diagonals read from left to right of a matrix in rows.
Solved using: Python.
VSTACK
Stacks arrays vertically into a single column in Excel.
Track Org Role Changes
Challenge No. 178: Create a corresponding row in result table if there is a change in either role or org.
Solved using: R.
Pivot for Time Entries by Date
Challenge No. 418: Pivot the given table for Date / Emp ID combinations with Min and Max Time.
Solved using: Python in Excel.
Pivot Using Suffix Headers
Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Square Digits Until Single Number
Challenge No. 412: Square the individual digits of a number and sum them.
Solved using: Python in Excel.
Calculate Agent Commission Totals
Challenge No. 172: Find the total commission paid to each agent along with a Grand Total row.
Solved using: R.
Normalize Table from Merged Cells
Challenge No. 409: This challenge was contributed by Taeyong Shin
Unmerge merged cells, separate characters separated by delimiters, and create a normalized table.
Solved using: Python in Excel.
Department Totals and Summary
Challenge No. 165: Insert the total row containing count of employees and sum of salary at the bottom of each dept groups.
Solved using: R.
Summarize by Five-Year Brackets
Challenge No. 403: Generate the Sum of Value and % of Value for year brackets of 5 years each.
Solved using: Python in Excel.
Fill Missing Months Default
Challenge No. 159: For a give name and year combination, if a month is missing between 1 and 12 then enter that month number with a default sales of 100.
Solved using: Python in Excel.