Challenge No. 369: Faro Shuffle – Divide the data in two equal parts (data will always be even, so two equal parts).
Solved using: DAX.
COUNTA
Counts the number of non-empty cells in a range in Excel.
Find missing terms in arithmetic progressions
Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
Sort Cities by Populated
Challenge No. 169: Order the cities columns on the basis of number of cells populated in descending order.
Solved using: Python.
Reverse Cities Columns
Challenge No. 159: Reverse all columns from Cities1 to Cities5.
Solved using: Power Query (List.RemoveNull, List.Reverse, List.Transform).
Generate Cartesian product of values
Challenge No. 34: Generate the Cartesian product as shown.
Solved using: SQL.
Table Transformation! Part 9
Challenge No. 89: Product sales information is provided in the question table.
Solved using:Excel (COUNTA, FILTER, HSTACK), Power Query (List.Transform, Table.SelectRows, Table.Skip), Python, Python in Excel, and R.
Row Combinations
Challenge No. 3: Extract all possible combinations of ID and result in the right-side table.
Solved using:Excel (BYROW, COUNTA, DROP), Power Query (List.Transform), Python, and Python in Excel.