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.
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.
Generate Vigenere Cipher Grid
Challenge No. 302: Generate Vigenere Cipher Grid.
Solved using: Python.
List the Polydivisible numbers
Challenge No. 301: List the Polydivisible numbers.
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.
Fill Grid Skipping Values
Challenge No. 300: Fill in 10×8 grid with numbers sequentially skipping X.
Solved using: Python in Excel.
Creating a Recruitment Plan from Headcount
Challenge No. 50: Create a Recruitment plan from the Projected Headcount.
Solved using: Python.
Split words by half total alphabet score
Challenge No. 299: Consider a=1..
Solved using: Python in Excel.
Fill Alphabets in Pattern Columns
Challenge No. 110: Fill in the alphabets from Names column in Name1.
Solved using: Python in Excel.