Groups rows in a table based on specified columns and applies aggregations in Power Query.
Challenge No. 12: (Excel formulas also welcome)
If there is a sequence missing for a given ID, fill in the missing sequence and repeat the row above for all other columns.
Solved using: Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group).
Challenge No. 20: List the distinct Subjects and Students who have scored the highest marks in those subjects along with Marks scored by them.
Solved using: Python in Excel.
Challenge No. 75: In the Question table, the order date for different products is provided (determined by positive quantity).
Solved using:DAX, Excel (CHOOSECOLS, FILTER, HSTACK), Power Query (Table.AddColumn, Table.Group, Table.SelectRows), Python, R, and SQL.
Challenge No. 74: Customer information including Name, Family, Phone, and Website is provided in the question table.
Solved using:Excel (ARRAYTOTEXT, FILTER, HSTACK), Power Query (List.Difference, List.Distinct, Text.Combine), Python, and R.
Challenge No. 69: In Table 1, sales transactions are provided, and the state of each customer is presented in Table 2.
Solved using:Excel (FILTER, HSTACK, LAMBDA), Power Query (Table.AddColumn, Table.Group), Python, R, and SQL.
Challenge No. 61: In Question Table 1, sales transactions are provided.
Solved using:Excel (FILTER, HSTACK, IF), Power Query (Table.Group, Table.Sort), Python, R, and VBA.
Challenge No. 55: In the question table, transactions for different products are presented.
Solved using:Excel (FILTER, HSTACK, INDEX), Power Query (List.Distinct, Table.Group, Table.Pivot), Python, and R.
Challenge No. 54: The table presents the actual progress of three projects at the end of each month, but some values are missing.
Solved using:Excel (DATE, DROP, EOMONTH), Power Query (List.Transform, Table.Group, Table.TransformColumnTypes), Python, and R.
Challenge No. 51: In the Question Table, historical sales data are provided.
Solved using:Excel (BYROW, HSTACK, LAMBDA), Power Query (List.Contains, List.ContainsAll, List.Transform), Python, and R.
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.
