Challenge No. 81: Interchange the position of 1st row with 2nd, 3rd with 4th, 5th with 6th and so on.
Solved using: SQL.
TOCOL
Converts a range or array into a single column in Excel.
Data Cleaning! Part 1
Challenge No. 98: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, but in a disorganized order.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Contains, Text.Split), Python, Python in Excel, and R.
Top 4 Winner and Runner-up
Challenge No. 78: — This week will be FIFA World Cup week.
Solved using: SQL.
Last Inventory Level!
Challenge No. 95: In the Question table, monthly inventory levels of products are provided.
Solved using:Excel (BYROW, FILTER, HSTACK), Google Sheets, Power Query (List.RemoveNull, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Count Team Wins
Challenge No. 46: List the Teams and the number of matches won by them.
Solved using: Python in Excel.
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.
Flexible Result Table Creation
Challenge No. 11: (Excel formulas also welcome)
Generate Result table as shown.
Solved using: Power Query (List.Distinct, Table.AddColumn, Table.Pivot).
Dynamic Result Table Generation
Challenge No. 10: (Excel formulas also welcome)
Generate Result table as shown.
Solved using: Power Query (Table.AddColumn, Table.SelectRows, Table.Sort).
Normal Distribution!
Challenge No. 84: Normal distribution was a kind of nightmare in university for me, but now let’s solve it using Excel.
Solved using:Excel (HSTACK, IF, INDEX), Power Query (Table.AddColumn), Python, Python in Excel, R, and VBA.
Words Around SELECT
Challenge No. 16: Provide a formula to list all bird names which appear immediately before and after SELECT in range A2:A20.
Solved using: Python in Excel.