Challenge No. 11: Cryptography Challenge – Caesar’s Cipher
Shift the each digit by values given in column B.
Solved using: Python in Excel.
RIGHT
Extracts a specified number of characters from the end of a text string in Excel.
Oeis Sequence
Challenge No. 53: The On-Line Encyclopedia of Integer Sequences presents several number sequences based on specific rules.
Solved using:Excel (FILTER, LAMBDA, LEFT), Power Query (List.Transform), Python, and R.
Custom Grouping! Part 2
Challenge No. 46: The “Question” table provides a list of Product IDs.
Solved using:Excel (CHOOSECOLS, DROP, FILTER), Power Query (Table.Group, List.Transform, Text.End), Python, and R.
Convert Number To Text!
Challenge No. 22: Convert the numbers in column B to the text like column H
.
Solved using:Excel, Power Query, and R.
Table Transformation! Part 1
Challenge No. 1: On various dates, the cumulative sales values (from the beginning of the year) for different products are presented (in the Question table).
Solved using:Excel (DROP, FILTER, HSTACK), and Power Query (Table.AddColumn, Table.TransformColumnTypes).