Challenge No. 89: Generate Result table on the basis of problem tables.
Solved using: Power Query.
⭐️⭐️⭐️⭐️⭐️⭐️Complex
Transpose to Desired Table Format
Challenge No. 84: Transpose the problem table into result table.
Solved using: Excel VBA.
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.
Sort Results by House and Name
Challenge No. 67: Generate result table and sort on House & Name.
Solved using: Power Query (Table.AddColumn).
List Sales Figures Across Dates
Challenge No. 48: — Input table Quantity data is wrong in picture.
Solved using: SQL.
Monthly and Quarterly Sales Difference
Challenge No. 23: Generate the resultant table.
Solved using: Power Query.