Stacks arrays horizontally into a single row in Excel.
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.
Challenge No. 78: — This week will be FIFA World Cup week.
Solved using: SQL.
Challenge No. 77: — This week will be FIFA World Cup week.
Solved using: SQL.
Challenge No. 75: — This week will be FIFA World Cup week.
Solved using: SQL.
Challenge No. 97: In the question table, the population data for cities A, B, and C are provided for different years.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Challenge No. 74: — This week will be FIFA World Cup week.
Solved using: SQL.
Challenge No. 72: — This week will be FIFA World Cup week.
Solved using: SQL.
Challenge No. 71: — This week will be FIFA World Cup week.
Solved using: DAX.
Challenge No. 69: — This week will be FIFA World Cup week.
Solved using: SQL.
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.
