Challenge No. 240: Now rotation has to be done for both columns and rows.
Solved using: Power Query.
COLUMNS
Returns the number of columns in an array or range in Excel.
Add Index Column! Part 2
Challenge No. 116: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (CHOOSECOLS, CHOOSEROWS, COLUMN), Google Sheets, Power Query (List.Alternate, Table.AlternateRows, Table.Column), Python, Python in Excel, and R.
Generate Concatenation Table
Challenge No. 110: Generate the result table.
Solved using: SQL.
Reverse Rows and Columns
Challenge No. 108: Reverse the rows and columns both.
Solved using: SQL.
Repeat Winners within 20 Years
Challenge No. 70: — This week will be FIFA World Cup week.
Solved using: SQL.
Find Common Animals
Challenge No. 13: Provide a formula to generate the list of animals who are common in all 3 columns.
Solved using: Python in Excel.