Challenge No. 371: This problem is contributed by Mehmet Çiçek
Find the list of products (alphabetically sorted) for the date range given in columns H & I from the table given in columns A to F.
Solved using: DAX.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Alternate Letters and Numbers
Challenge No. 366: Arrange the given characters in such a fashion that alphabets occupy all odd positions and numbers occupy even position in the order in which they appear.
Solved using: Python.
Extract Longest Alphanumeric Segment
Challenge No. 361: Separate out the largest sequences of English alphabets and numbers from the given strings.
Solved using: Python in Excel.
Stack Matrix Diagonals Horizontally
Challenge No. 358: Stack both the diagonals of n x n metrices horizontally.
Solved using: Python in Excel.
Exclude Weekend Vacation Dates
Challenge No. 139: Prepare the Result table.
Solved using: DAX.
Transpose People Table
Challenge No. 138: Transpose the problem table into result table.
Solved using: R.
Map Groups to Company
Challenge No. 137: Generate result table on the basis of 2 problem tables.
Solved using: Python in Excel.
Find Longest Consecutive Sequence
Challenge No. 347: List the largest group of consecutive numbers in each column.
Solved using: R.
Unpivot and Merge Names
Challenge No. 132: Unpivot the problem table into result table.
Solved using: Python in Excel.
Sort odd positioned numbers
Challenge No. 341: Sort the numbers at odd positions.
Solved using: Python in Excel.