Challenge No. 38: Sort Cookies into 2 groups: with Duplicate Price & with Unique prices Dynamic array function allowed but
Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Table.FromColumns
Converts a list of column lists into a table in Power Query.
Two-Column Text!
Challenge No. 94: In the question table, texts are provided for different groups.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Split, List.Transform, Table.ExpandTableColumn), Python, Python in Excel, and R.
Character-Based Triangular
Challenge No. 68: Create a formula to receive a number n as input and generate a Triangular with a height equal to n using “*” characters.
Solved using:Excel (IF, LAMBDA, LET), Power Query (List.Repeat, List.Transform, Table.FromColumns), Python, R, and VBA.
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.
Data Normalization
Challenge No. 12: In every decision-making process, the first step is to normalize the data.
Solved using:Excel (BYCOL, LAMBDA), Google Sheets, Power Query (List.Transform, Table.FromColumns, Table.ToColumns), R, and VBA.