Challenge No. 117: Equally divide the payment over current quarter and next 3 quarters.
Solved using: Python in Excel.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Extracting Whole Route
Challenge No. 53: Generate a whole route for the airlines
e.
Solved using: R.
Replace Consecutive X!
Challenge No. 185: In the ID column, Replace all instances of “X” if it appears consecutively more than once with just an “X”.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Text.Combine, Table.Group, Table.TransformColumns), Python, Python in Excel, and R.
Forecast Monthly Rounded Growth
Challenge No. 116: Prepare the forecast from Jul onwards.
Solved using: Python in Excel.
Generate Output Table from Data
Challenge No. 113: Generate result table from problem table.
Solved using: Python in Excel.
Table Transformation! Part 22
Challenge No. 181: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Alternate, List.Transform, Table.Group), Python in Excel, and R.
Generate Vigenere Cipher Grid
Challenge No. 302: Generate Vigenere Cipher Grid.
Solved using: Python.
Summarize Hours by Role Title
Challenge No. 112: Generate the result table from problem table where Hours are summation for a particular role.
Solved using: Python in Excel.
Hierarchical Structure!
Challenge No. 180: In the question table, parents and their children with different IDs are listed.
Solved using:Excel, Google Sheets, Power Query, Python in Excel, and R.
Sort and Position Team Members
Challenge No. 111: Fill in the individuals in Ind columns and their positions in Team Members in Ind_Pos columns.
Solved using: Python in Excel.