Challenge No. 209: Insert 1., 2.
Solved using: Power Query (List.Transform).
LAMBDA
Creates custom reusable functions in Excel.
Sum Bird Quantity Alphabetically
Challenge No. 64: Looks like yesterday’s problem was a difficult one as only one person responded.
Solved using: Power Query (Table.Group, Table.Sort).
Periodic Sales Summary!
Challenge No. 138: Based on the “transactions” table, summarize the sales for each month by breaking them into three periods:
P1: First 10 days of the month
P2: From the 11th to the 20th
P3: From the 21st onward.
Solved using:Excel (DAY, DROP, HSTACK), Google Sheets, Power Query (Date.Month, List.Distinct, Table.AddColumn), Python, Python in Excel, and R.
Pay All Quarters Customers
Challenge No. 208: Find those customers who have made at least one payment in all quarters in its range.
Solved using: Power Query.
Encrypt Using Date Cipher
Challenge No. 207: DATE CIPHER
Date cipher is a type of Caesar’s shift cipher where key is current date in YYYYMMDD format.
Solved using: Excel VBA.
Filter Values Based on Table
Challenge No. 61: Generate Result table on the basis of T1 and T2.
Solved using: Power Query (List.Distinct, Table.Group, Table.Pivot).
List All Dudeney Numbers
Challenge No. 204: A Dudeney number is a positive integer that is a perfect cube such that the sum of its decimal digits is equal to the cube root of the number.
Solved using: Power Query (List.Transform).
Classify Items as Used or New
Challenge No. 60: Generate the Result table from Problem table.
Solved using: Power Query (Table.AddColumn, Table.Split, Table.SplitColumn).
Encrypt Using Baconian Cipher
Challenge No. 203: Baconian Cipher
(This problem is case insensitive)
A is 0, B is 1, C is 2.
Solved using: Power Query.
Column Splitting! Part 1
Challenge No. 136: Split the ID values where a character is repeated consecutively.
Solved using:Excel (CONCAT, DROP, IF), Google Sheets, Power Query (List.Transform, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.