Challenge No. 159: Reverse all columns from Cities1 to Cities5.
Solved using: Power Query (List.RemoveNull, List.Reverse, List.Transform).
REDUCE
Reduces an array to a single value using an accumulator function 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.
Replace Masked Characters
Challenge No. 131: The strings given in column A have some alphabets which are masked i.
Solved using: Excel VBA.
Reconciliation!
Challenge No. 110: After reconciling the company’s bank transactions with the records in the financial department, discrepancies were found between 5 rows of bank transactions and 7 rows of financial records.
Solved using: Excel.
Generate Fibonacci Strings
Challenge No. 104: Generate n Fibonacci strings for given first two terms.
Solved using: SQL.
Align Names by Cities
Challenge No. 86: Align the names under their respective cities.
Solved using: Power Query.
Pascal Case to Snake Case
Challenge No. 84: Change Pascal Case to Snake Case.
Solved using: Python in Excel.
Data Cleaning! Part 1
Challenge No. 98: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, but in a disorganized order.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Contains, Text.Split), Python, Python in Excel, and R.
Linear Interpolation!
Challenge No. 97: In the question table, the population data for cities A, B, and C are provided for different years.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Last Inventory Level!
Challenge No. 95: In the Question table, monthly inventory levels of products are provided.
Solved using:Excel (BYROW, FILTER, HSTACK), Google Sheets, Power Query (List.RemoveNull, Table.AddColumn, Table.Group), Python, Python in Excel, and R.