Challenge No. 690: The value associated with alphabets are given in the grid next to the alphabets.
Solved using: Python in Excel.
WRAPROWS
Wraps values into rows in Excel.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.
Unpivot the table, add order
Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
Calculate Name-Based Durations
Challenge No. 573: Work out the durations in hours against all names.
Solved using: Python.
Align Rowwise Data
Challenge No. 520: Align the data as given in answer expected.
Solved using: Python in Excel.
Subject Scores Transposition
Challenge No. 223: Transpose the problem table into result table.
Solved using: Python.
Extract Entries from Running Total
Challenge No. 500: Get the individual entries from the running total which is across the row and continues to the next rows.
Solved using: Python.
Pivot Yes No Percentages
Challenge No. 205: From tables T1 and T2, generate the result table.
Solved using: Python in Excel.
Encrypt Using Columnar Cipher
Challenge No. 442: Columnar Transposition Cipher
Write the keyword in a row
Rank the letters of keyword as per their position in English language in descending order.
Solved using: Python in Excel.
Encrypt Using Bifid Cipher
Challenge No. 437: Bifid Cipher with Keyword
Suppose we want to encrypt the message “BATTLE” and keyword is “ROTORS”.
Solved using: Python in Excel.