Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.
REDUCE
Reduces an array to a single value using an accumulator function in Excel.
Swap Letters by Index Pair
Challenge No. 570: For a given string, interchange the alphabets by swapping positions given in Numbers column.
Solved using: Python in Excel.
Transpose problem table into result
Challenge No. 249: Transpose problem table into result table.
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.
Unstack Columns to Rows
Challenge No. 243: Transform the problem table into result table as shown.
Solved using: Python.
Sum-Based Neighboring Grid Fill
Challenge No. 532: Apologies!! Scheduling didn’t work today.
Solved using: Python in Excel.
Spread Yearly Rows to Columns
Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.
Align Rowwise Data
Challenge No. 520: Align the data as given in answer expected.
Solved using: Python in Excel.
Perfect Square Predecessor Checker
Challenge No. 517: Arrange the given numbers in such a fashion that sum of preceding + current number is a perfect square.
Solved using: Python in Excel.
Normalize Tabular Data
Challenge No. 515: Normalize the data given in columns A to B as given in Answer Expected.
Solved using: Python.