For this particular example,
- the variables of interest are stored as key:value pairs and
- a single data cell could contain multiple (unknown) number of key:value pairs.
The objective is to separate these key-value pairs and store the values in corresponding key columns.
The hadleyverse packages make this task a fairly simple one, especially tidyr, stringr and magrittr.