Challenge No. 179: If a character appears consecutively, then remove all consecutive characters other than first.
Solved using: Excel VBA.
CONCAT
Concatenates text from multiple cells without a delimiter in Excel.
Route Cipher Encrypt
Challenge No. 178: Route Cipher
Encrypt the given Strings.
Solved using: Power Query.
XOR Cipher for Message
Challenge No. 173: This time, in step 3 in place of adding both the numbers, we need to do Bitwise XOR operation.
Solved using: Power Query (List.Transform).
Find Missing Alphabets
Challenge No. 172: Find the missing English Alphabets from First Ladies column.
Solved using: Power Query.
Pad In The Middle!
Challenge No. 125: For the IDs in the table, insert zeros between the text and numbers to ensure that each ID has exactly 6 characters.
Solved using:Excel (CONCAT, ISNUMBER, LAMBDA), Google Sheets, Power Query (Text.Repeat, Table.AddColumn), Python, Python in Excel, and R.
Symbol Replace by Frequency
Challenge No. 163: If an alphabet appears once in a word, replace it with a “?”.
Solved using: Power Query (Table.AddColumn).
Vernam Cipher Encrypt
Challenge No. 162: Vernam Cipher (also known as One time pad cipher)
1.
Solved using: Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip).
Reverse Long Words
Challenge No. 161: If a word in sentence has length > Number, then reverse that word.
Solved using: Power Query (Text.Combine).
Workday Count Between Dates
Challenge No. 157: Find the number of workdays between two dates (From & To) for Weekends given in column E.
Solved using: Power Query (NETWORKDAYS.INTL).
Polybius Cipher Encrypt
Challenge No. 155: Polybius cipher
Encrypt the text in column I as per grid in A2:G8.
Solved using: Python in Excel.