Challenge No. 60: Generate the Result table from Problem table.
Solved using: Power Query (Table.AddColumn, Table.Split, Table.SplitColumn).
Table.TransformColumns
Applies a function to one or more columns in a table in Power Query.
Mark Unique or Not Unique
Challenge No. 56: Populate Unique and Not Unique for different fruits against each garden depending upon its count.
Solved using: Power Query (List.Distinct, Table.Group, Table.TransformColumns).
Return Repeat Customers
Challenge No. 37: Return only dates with repeat customers and repeated customers Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Multi Replacement!
Challenge No. 115:
Replace “q” and “000” in the Product ID and Customer ID columns with “-“.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Text.Replace, Table.ReplaceValue, Table.TransformColumns), Python, Python in Excel, R, SQL, and VBA.
Clean Data and Restructure Table
Challenge No. 8: (Excel formulas also welcome)
Clean the data and generate the result table as shown.
Solved using: Power Query (Table.AddColumn, Table.TransformColumns).
Count Unique Subjects Per Row
Challenge No. 6: (Excel formulas also welcome)
Count the no.
Solved using: Power Query (Table.TransformColumns).
Text Cleaning!
Challenge No. 64: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, with a default value of 1 for missing quantities.
Solved using:Excel (DROP, HSTACK, IFERROR), Power Query (List.Transform, Text.Split, Table.Split), Python, R, and VBA.