Stacks arrays vertically into a single column in Excel.
Challenge No. 135: Find the number of occurrences of the “+-+” pattern across the test IDs for each product.
Solved using:Excel (BYROW, CONCAT, DROP), Google Sheets, Power Query (List.Range, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Challenge No. 58: Starting opening balance (OB) = 100 (This is given and you will need to work out OB for Serials 2 through 9)
Hence, Serial no.
Solved using: SQL.
Challenge No. 134: From the “transactions” in the provided table, filter those that occurred in the last 7 days of the month.
Solved using:Excel (CHOOSECOLS, DAY, EOMONTH), Google Sheets, Power Query (Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and SQL.
Challenge No. 190: Find the unique pairs of numbers whose sum is the maximum.
Solved using: Python in Excel.
Challenge No. 131: Transform the question structure into the result structure.
Solved using:Excel (HSTACK, LET, ROWS), Google Sheets, Power Query (List.Skip, List.Split, List.Transform), Python, Python in Excel, and R.
Challenge No. 54: From the transaction table, generate output as shown.
Solved using: Power Query.
Challenge No. 127: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Challenge No. 51: Distribute the amount over month-year for every item.
Solved using: Power Query (List.Transform).
Challenge No. 50: If there is a discontinuity in dates for a Store, fill in the missing dates with details of previous records and also fill in the sequence of record numbers for a customer in that store.
Solved using: SQL.
Challenge No. 49: Generate the output table shown.
Solved using: SQL.
