Challenge No. 188: Sort Col 1 through 5 column wise on the basis of frequency.
Solved using: Power Query (List.Transform).
Table Transformation! Part 13
Challenge No. 131: Transform the question structure into the result structure.
Solved using:Excel (HSTACK, LET, ROWS), Google Sheets, Power Query (List.Skip, List.Split, List.Transform), Python, Python in Excel, and R.
Transform Input to Output
Challenge No. 55: This time problem statement is short.
Solved using: Power Query.
Find Anagram Word Pairs
Challenge No. 187: An Anagram is a word which is made by rearranging the letters of another word.
Solved using: Power Query.
Compare Odd Even Counts
Challenge No. 186: If odd numbers are less, then post odd numbers.
Solved using: Power Query (List.Transform).
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.
Months With 5 Weekends
Challenge No. 184: List the years in this century which are having at least 2 months which had 5 Fridays, 5 Saturdays and 5 Sundays.
Solved using: Python in Excel.
List Tetradic Numbers
Challenge No. 183: List Tetradic numbers from column A.
Solved using: Python in Excel.
Fill Arithmetic Progression
Challenge No. 182: Find the missing numbers in Arithmetic Progressions given.
Solved using: Python in Excel.