Challenge No. 302: Generate Vigenere Cipher Grid.
Solved using: Python.
TOROW
Converts an array into a single row in Excel.
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.
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.
Maximize Buy-Sell Profit Days
Challenge No. 287: You will need to buy first and sell later.
Solved using: Python in Excel.
Custom Grouping! Part 11
Challenge No. 161: Extract the list of dates associated with each product and display them under each other in separate columns.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Eight Queens Puzzle!
Challenge No. 150: Theeight-queenss puzzle is the problem of placing eight chess queens on an 8×8 chessboard so that no two queens threaten each other; thus, a solution requires that no two queens share the same row, column, or diagonal.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Combine, List.Transform), and Python in Excel.
List Question Options Summary
Challenge No. 59: Generate the result table where –
Questions should be listed in headers.
Solved using: Power Query (List.Transform, Table.SelectRows).
Cartesian Product!
Challenge No. 128: Write all the 3 character words by using “A”,”B”,C”, AND “D”.
Solved using:Excel (LAMBDA, LET, REDUCE), Google Sheets, Power Query (List.Transform, List.TransformMany), Python, Python in Excel, and R.
Align Names by Cities
Challenge No. 86: Align the names under their respective cities.
Solved using: Power Query.
Table Transformation! Part 7
Challenge No. 48: The table below presents various combinations of heuristic algorithms used to solve a problem, each combination separated by a “+”.
Solved using:Excel (COUNTIF, HSTACK, IF), Google Sheets, Power Query (List.Distinct, List.Transform, Table.AddColumn), Python, and R.