Challenge No. 92: In the question table, some cells (highlighted) are missing, but a character determines how to fill them based on the following rule:
R = right cell
L = left cell
U = upper cell
D = down cell.
Solved using:Excel (IF, IFS, INDEX), Power Query (List.PositionOf, List.Transform), Python, Python in Excel, and R.
SWITCH
Returns a value based on a given expression in Excel.
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.
