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
