A selection of data manipulation tasks that I often encounter prior to modeling, that is, prepare the dataset for exporting to a standard statistics package.
Multiple indicators rolled/concatenated into a single column; for example:
Column A needs splitting into 2 separate columns:
one for the treatment label, one for the day indicator, like so:
Which is accomplished by using text extractor functions: