Challenge No. 120: Fill in all empty values with average of contiguous non-empty values on immediate left.
Solved using: Power Query (List.Transform, Table.Column, Table.ColumnNames).
List.Transform
Applies a function to each element in a list in Power Query.
Matrix Calculation! Part 1
Challenge No. 188: Create a formula that, for any given value of ‘n’, generates an ‘n x n’ identity matrix where all values are 0, except for the diagonal (primary) values, which should be 1.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Transform), Python, and Python in Excel.
Remove letters in Planets column from Author Column
Challenge No. 315: Remove the English letters appearing in Planets column from Author Column.
Solved using: Python in Excel.
Generate the result table with Tn = T(n-2) & Tn
Challenge No. 313: Generate the result table.
Solved using: Python in Excel.
List Portmanteau words
Challenge No. 308: List Portmanteau words.
Solved using: Python in Excel.
Add Index Column! Part 6
Challenge No. 182: In the question table, assign an index to the blank cells, starting from 1.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Combine, List.Split, List.Transform), Python, Python in Excel, and R.
Table Transformation! Part 22
Challenge No. 181: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Alternate, List.Transform, Table.Group), Python in Excel, and R.
Summarize Hours by Role Title
Challenge No. 112: Generate the result table from problem table where Hours are summation for a particular role.
Solved using: Python in Excel.
Sort and Position Team Members
Challenge No. 111: Fill in the individuals in Ind columns and their positions in Team Members in Ind_Pos columns.
Solved using: Python in Excel.
Split words by half total alphabet score
Challenge No. 299: Consider a=1..
Solved using: Python in Excel.