Challenge No. 604: Today’s problem is contributed by Ahmad Syawal Ramli
Generate the area enclosed in red from problem table.
Solved using: Power Query.
DROP
Removes a specified number of rows or columns from an array in Excel.
Identify Missing Number Ranges
Challenge No. 603: Find the missing numbers in the grid given between the smallest and the largest numbers.
Solved using: Python.
Transpose table, compute gross profit
Challenge No. 278: Transpose the table as shown where sum of amount shown is gross profit which is Revenue – Cost.
Solved using: Python.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
Transpose table, summing values from
Challenge No. 275: Transpose the problem table into result table where value is sum of Values from problem table.
Solved using: Python.
Sequential Group Numbering Logic
Challenge No. 596: This challenge is contributed by Ankur Sharma
Populate 1, 2, 3.
Solved using: Python.
Transpose the table as shown
Challenge No. 273: Transpose the table as shown.
Solved using: Python.
List Consecutive Streak Indexes
Challenge No. 590: If there are more than one consecutive streaks of H or T, then list the Indexes of those.
Solved using: Python in Excel.
Cross Product with Repeats
Challenge No. 585: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: Python.
Cross Product with Multiples
Challenge No. 584: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: R.