To pull strings out of a sentence based on ;#

[shiva]

Hi

Seeking some help. I have a list of Suppliers and associated risk with those suppliers.

I need a formula to pick all the risks for a supplier as a list (dynamic formula)

Attaching a sheet and how the output should be

Thanks in advance

 

[Deepak]

Hi,

If u change the layout this would be useful.

 

[shiva]

Thanks Deepak