Challenge No. 178: Find the prime Factors of numbers in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Transform), Python, Python in Excel, R, and VBA.
List.Transform
Applies a function to each element in a list in Power Query.
Custom Grouping! Part 16
Challenge No. 176: Group every five rows of the question table and then provide some of quantity for each group.
Solved using:Excel (GROUPBY, HSTACK, LAMBDA), Google Sheets, Power Query (Table.Group, List.Transform, Table.AddIndexColumn), Python, Python in Excel, and R.
Add Time to Duration Format
Challenge No. 105: Add Text Time and Add columns together and present result in duration format i.
Solved using: Excel VBA.
Company Totals for Items/Amount
Challenge No. 104: Prepare the result table from problem table.
Solved using: Python.
Unique Dept-Name Combinations
Challenge No. 102: Prepare unique combinations of Dept and corresponding names.
Solved using: Power Query (List.Transform).
Generate Demlo Numbers diamond
Challenge No. 285: Generate Demlo Numbers diamond.
Solved using: R.
Table Transformation! Part 20
Challenge No. 171: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform), Python, Python in Excel, and R.
Unique Combinations Matching Sum
Challenge No. 284: Find out unique combination of numbers from column A containing N numbers given in column B which sums to column C.
Solved using: Python in Excel.
Find Divisible Substrings Sorted
Challenge No. 281: List all the substrings from Number1 which are divisible by Number2.
Solved using: Python in Excel.
Extract From Text! Part 7
Challenge No. 169: Similar to Challenge 149, extract the texts between the pairs of the characters listed below.
Solved using:Excel (ARRAYTOTEXT, LAMBDA, MAP), Google Sheets, Power Query (List.Split, List.Transform, Text.Combine), Python, Python in Excel, and R.