Reverse pivots with multiple columns - Transform efficiently without lots of tables

Hi,   I have a data table from an external source with two fields. Field one is a unique ID. Field 2 is a list of categories in the format "category1; category2; category 3..." There can be just on...