Challenge No. 252: Prepare the result table from problem table.
Solved using: Python.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Pivot the problem table into
Challenge No. 251: Pivot the problem table into result table.
Solved using: Python.
Calculate Finish Stock and Starting
Challenge No. 250: Calculate Finish Stock and Starting Stock.
Solved using: Python.
Transpose problem table into result
Challenge No. 249: Transpose problem table into result table.
Solved using: Python.
Transpose the problem table into
Challenge No. 248: Transpose the problem table into result table.
Solved using: Python.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.
Prepare the result table on
Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.
Top Two Department Salaries
Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.
For each Deal, list the
Challenge No. 246: For each Deal, list the name of the persons who handled the deal most recently.
Solved using: Python.
Get names in a sorted
Challenge No. 245: Get names in a sorted order under subject columns.
Solved using: Python in Excel.