Challenge No. 55: This time problem statement is short.
Solved using: Power Query.
By Topic
Challenges categorized by topic.
First In First Out (Fifo)!
Challenge No. 130: Consider a warehouse operating with an initial value of 0 and following a First-In, First-Out (FIFO) approach.
Solved using:Excel (FILTER, TAKE), Google Sheets, Power Query (Table.SelectRows), Python, Python in Excel, and R.
List Buy and Sell Balances
Challenge No. 54: From the transaction table, generate output as shown.
Solved using: Power Query.
Fill Arithmetic Progression
Challenge No. 182: Find the missing numbers in Arithmetic Progressions given.
Solved using: Python in Excel.
Custom Grouping! Part 6
Challenge No. 129: The stock prices for the given dates are provided in the table.
Solved using:Excel (DROP, GROUPBY, HSTACK), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python in Excel, and R.
Convert Dates to US Format
Challenge No. 181: Convert DMY text dates to MM/DD/YYYY format.
Solved using: Power Query.
Cartesian Product!
Challenge No. 128: Write all the 3 character words by using “A”,”B”,C”, AND “D”.
Solved using:Excel (LAMBDA, LET, REDUCE), Google Sheets, Power Query (List.Transform, List.TransformMany), Python, Python in Excel, and R.
Route Cipher Encrypt
Challenge No. 178: Route Cipher
Encrypt the given Strings.
Solved using: Power Query.
Add Index Column! Part 4
Challenge No. 127: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Distribute Amount Monthly
Challenge No. 51: Distribute the amount over month-year for every item.
Solved using: Power Query (List.Transform).