Challenge No. 180: In the question table, parents and their children with different IDs are listed.
Solved using:Excel, Google Sheets, Power Query, Python in Excel, and R.
Data Transformation
Transforming raw data into useful formats.
The Knight’S Tour!
Challenge No. 170: Given a N*N board with the Knight placed on the first block of an empty board.
Solved using:Excel, Python, and Python in Excel.
Traveling Salesman Problem
Challenge No. 90: The Traveling Salesman Problem (TSP) is a well-known problem in mathematics used to determine the optimal travel path that visits all cities exactly once with the minimum cost.
Solved using:Excel, Power Query, 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.
Highlight Merged Cells
Challenge No. 24: In Conditional Formatting write a formula to highlight the merged cells.
Solved using:Excel, R, and VBA.
Hierarchy Transformation
Challenge No. 20: The question table provides information about products, which are organized into three levels based on the length of their codes, and we want to transform this table into the result table wich each level is displayed in separate columns.
Solved using:Excel (FILTER, HSTACK, LEFT), Power Query (List.Transform), Python, and R.
Transform Data Format!
Challenge No. 16: Change the format of the data from the question table to that of the result table.
Solved using:Excel, Power Query, and R.