Challenge No. 178: Create a corresponding row in result table if there is a change in either role or org.
Solved using: R.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Split and Running Total Rows
Challenge No. 176: Generate the result table from problem table.
Solved using: Python in Excel.
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.
Roman Palindromic Numbers
Challenge No. 410: List all decimal numbers whose Roman equivalents are Palindromic.
Solved using: Python.
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.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
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.