Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
CONCAT
Concatenates text from multiple cells without a delimiter in Excel.
Remove letters in Planets column from Author Column
Challenge No. 315: Remove the English letters appearing in Planets column from Author Column.
Solved using: Python in Excel.
Find texts that are ATBASH Palindromes
Challenge No. 314: ATBASH Palindrome – In ATBASH cipher, we replace a with z, b with y, c with x.
Solved using: Python in Excel.
Generate the result table with Tn = T(n-2) & Tn
Challenge No. 313: Generate the result table.
Solved using: Python in Excel.
Column Splitting! Part 4
Challenge No. 186: Split the ID into two columns:
The first column should contain all vowels (A, E, I, O, U).
Solved using:Excel (BYROW, CONCAT, HSTACK), Google Sheets, Power Query (Text.Combine, Text.Remove, Text.Select), Python, Python in Excel, and R.
Sort the digits of given numbers in descending order
Challenge No. 311: Sort the digits of given numbers in column A in descending order.
Solved using: Python in Excel.
List all Palindromic phrases
Challenge No. 307: List all Palindromic phrases.
Solved using: Python in Excel.
Find Palindromic Numbers via 196
Challenge No. 296: 196-Algorithm – Take any positive integer of two digits or more, reverse the digits, and add to the original number.
Solved using: Python in Excel.
Words in Alphabetical Order
Challenge No. 293: Provide a formula to list all words from A2:A10 where English alphabets appear in alphabetical order.
Solved using: Python in Excel.
Generate Demlo Numbers diamond
Challenge No. 285: Generate Demlo Numbers diamond.
Solved using: R.