Re-order text values within column

[SDP]

Hello All, I have column called Delay. My final output should look like second table 2. How can I do it in designer? Please let me know. 

Table 1

Delay
Pay Delay;ABC Delay;Client Delay	1
Pay Delay;Client Delay	1
Pay Delay	1
ABC Delay;Pay Delay	1
ABC Delay;Client Delay;Pay Delay	1
ABC Delay;Client Delay	1
ABC Delay	1
Client Delay;ABC Delay	1
Client Delay	1

Final column looks like below, (Table 2)

Delay
Pay Delay;ABC Delay;Client Delay	2
Pay Delay;Client Delay	1
Pay Delay	1
ABC Delay;Pay Delay	1
ABC Delay;Client Delay;Pay Delay
ABC Delay;Client Delay	2
ABC Delay	1
Client Delay;ABC Delay
Client Delay	1

Thanks for your help.

SDP

[Felipe_Ribeir0 · Accepted solution]

Hi @SDP 

One way of doing this