Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
ROWS
Returns the number of rows in an array or range in Excel.
Find Isogram Calendar Dates
Challenge No. 265: An Isogram date is a two digits year date in which no digit occurs more than once.
Solved using: Power Query.
Insert Increasing Header Intervals
Challenge No. 90: Insert header row after 1 name, then after 2 names, then after 3 names and so on.
Solved using: Power Query.
Table Transformation! Part 18
Challenge No. 157: Transform the question structure into the result structure.
Solved using:Excel (HSTACK, INDEX, LAMBDA), Google Sheets, Power Query (List.Split, List.Transform, Text.Split), Python, Python in Excel, and R.
Rotate Rows and Columns
Challenge No. 240: Now rotation has to be done for both columns and rows.
Solved using: Power Query.
Filter Dates!
Challenge No. 148: For each customer, filter their first, last, and middle transactions from the provided “transactions” table.
Solved using:Excel (CHOOSEROWS, DROP, FILTER), Google Sheets, Power Query (Table.Combine, Table.Group), Python, Python in Excel, and R.
Create Simple Result Table
Challenge No. 76: Generate the result table from problem table.
Solved using: Power Query.
Validate Multi-Word Names
Challenge No. 233: List all valid names from A2:A11
The criteria for valid names are –
1.
Solved using: Power Query.
Even Result by Position Sum
Challenge No. 224: List the numbers where following result is an even number
Result = Sum of Digits at Odd positions – Sum of Digits at Even positions
Positions start at 1 not at 0.
Solved using: Python in Excel.
Sort Rows by Key Count
Challenge No. 223: Sort the rows in columns A through H as per Sort key.
Solved using: Power Query.