Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
TAKE
Returns a specified number of rows or columns from an array in Excel.
Create Weekly Group
Challenge No. 72: 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.
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.
Interleave Numbers into Letters
Challenge No. 506: Concat column B numbers into column 1 alphabets.
Solved using: Python.
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.
Normalize Staff Entries
Challenge No. 219: Normalise the table as shown.
Solved using: Python.
Fill Sequence and Compute Sum
Challenge No. 497: For given range A2:A100, populate 1, 2, 3.
Solved using: Python in Excel.
Show Transposed Amount Values
Challenge No. 216: Transpose the table as shown.
Solved using: Excel VBA.
Outstanding Loan Day Count
Challenge No. 215: Assuming today’s date is 7-Sep-24, pivot the table as shown for Outstanding loans.
Solved using: Python in Excel.