Table 1 Input is the initial data: Order IDOrder QtyStatus IDStatusScenarioOR_0000011473717;Delivered;Order Qty = # of Status (Normal)OR_00000210494086;94089;494090;494099;494100;494101;494102;494103;494104;494105Delivery Started;;Delivered;Delivered;Delivery Started;Delivered;Delivery Started;Delivery Started;Delivery Started;Delivered;one order with blank statusOR_0000037496038;517460;530925;Delivered;Delivered;Cancelled;Order Qty > # of Status Table 2 Output is the desired Alteryx output: Order IDOrder QtyStatusIDStatusOR_0000011473717DeliveredOR_00000210494086Delivery StartedOR_0000021094089 OR_00000210494090DeliveredOR_00000210494099DeliveredOR_00000210494100Delivery StartedOR_00000210494101DeliveredOR_00000210494102Delivery StartedOR_00000210494103Delivery StartedOR_00000210494104Delivery StartedOR_00000210494105DeliveredOR_0000037496038DeliveredOR_0000037517460DeliveredOR_0000037530925Cancelled How can I use RegEx to parse the StatusID and Status in table 1 by semicolon to generate table 2? The sample data file is attached. Thanks. Sample Data1.xlsx

Parse string with one or multiple delimiters using RegEx

Table 1 Input is the initial data:

Order ID	Order Qty	Status ID	Status	Scenario
OR_000001	1	473717;	Delivered;	Order Qty = # of Status (Normal)
OR_000002	10	494086;94089;494090;494099;494100;494101;494102;494103;494104;494105	Delivery Started;;Delivered;Delivered;Delivery Started;Delivered;Delivery Started;Delivery Started;Delivery Started;Delivered;	one order with blank status
OR_000003	7	496038;517460;530925;	Delivered;Delivered;Cancelled;	Order Qty > # of Status

Table 2 Output is the desired Alteryx output: