Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
CONCAT
Concatenates text from multiple cells without a delimiter in Excel.
Remove One Letter Palindrome
Challenge No. 699: Only one alphabet can be removed from Words list and it should become a palindrome.
Solved using: Python.
Repeat Non-Consecutive Characters
Challenge No. 694: Repeat every character in the string except those characters which appear consecutively.
Solved using: R.
Encrypt Words with Random Characters
Challenge No. 633: Encrypt the given words with following rules
1.
Solved using: Python.
Count Alphabetically Sorted Words
Challenge No. 601: Find the count of words in columns A through C if the words have sorted alphabets.
Solved using: Python in Excel.
Reapply Original Capitalization
Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.
Repeat Vowels by Position
Challenge No. 587: Repeat the vowels as per their order of occurrence.
Solved using: Python in Excel.
Cross Product with Repeats
Challenge No. 585: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: Python.
Cross Product with Multiples
Challenge No. 584: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: R.
Sort Consonants Keep Vowels
Challenge No. 576: Sort the consonants in given sentences while keeping the vowels wherever they are.
Solved using: Python.