Challenge No. 52: In the Question Table, numbers ranging from 1001 to 1018 are listed.
Solved using:DAX, Excel (COUNTIF, FILTER, IF), Power Query (List.Difference), Python, Python in Excel, R, SQL, and VBA.
VSTACK
Stacks arrays vertically into a single column in Excel.
Assignment Problem (Part 1)!
Challenge No. 49: Assignment Problem is a well-known problem for assigning tasks to different people by the minimum cost and we want to solve it with The Hungarian method within two challenges.
Solved using:Excel (BYCOL, BYROW, HSTACK), Power Query (List.Skip, List.Transform, Table.Column), Python, and R.
Table Transformation! Part 7
Challenge No. 48: The table below presents various combinations of heuristic algorithms used to solve a problem, each combination separated by a “+”.
Solved using:Excel (COUNTIF, HSTACK, IF), Google Sheets, Power Query (List.Distinct, List.Transform, Table.AddColumn), Python, and R.
Custom Grouping! Part 2
Challenge No. 46: The “Question” table provides a list of Product IDs.
Solved using:Excel (CHOOSECOLS, DROP, FILTER), Power Query (Table.Group, List.Transform, Text.End), Python, and R.
Combine Tables
Challenge No. 44: The question tables display product sales across various regions for the different months of spring.
Solved using:Excel (DROP, FILTER, HSTACK), Power Query (List.Distinct, Table.Column, Table.ColumnNames), Python, and R.
Revisit After Surgery!
Challenge No. 42: In the question table, a list of patients is provided who are scheduled to visit the doctor for consultations and surgery.
Solved using:Excel (CHOOSECOLS, DROP, FILTER), Power Query (Text.Combine, Table.Group, Table.SelectRows), Python, and R.
Connected People!
Challenge No. 37: In the question table, the IDs of 20 people who call each other are provided.
Solved using:Excel (FILTER, HSTACK, LAMBDA), Power Query (List.Transform, Text.Combine), Python, and R.
P & Down Grades!
Challenge No. 35: In our company, we utilize a grading system to evaluate the technical performance of our agents, assigning grades of C, B, A, and A+.
Solved using:Excel (DROP, FILTER, HSTACK), Power Query (Table.AddColumn, Table.Group), and R.
Table Transformation! Part 4
Challenge No. 32: In the question table, monthly sales and the percentage of total annual sales are provided.
Solved using:Excel (CHOOSECOLS, CHOOSEROWS, DROP), Power Query (Table.Column, Table.ColumnNames, Table.Sort), Python, and R.
From-To Matrix
Challenge No. 31: In the question table, the distances between various cities are provided.
Solved using:Excel (HSTACK, LAMBDA, LET), Power Query (Table.Column, Table.ColumnNames), Python, and R.