Find differences in cell text strings

[JP Romano]

Good morning/afternoon,

I think there is a way to do this with arrays, but I'm still pretty awful with them, so, hoping one of you can throw me an assist. Will try to explain here, but am also attaching a small sample of the data.

I have pipe separated values in three columns. Each cell starts with a category and counter (e.g. Topic (8), meaning there are 8 topics listed in the remainder of the string) and can have any number of values (including none). Each value consists of only one word - there are no multi word values, ever.

There will be anywhere from 5 to roughly 7,000 rows, though I've rarely seen files in excess of 250.

I need to find every value that is in column B, that is not in column C, and is not already in column D. Those should be dumped out into column E, pipe separated if possible, or alternated, each value dumped into the first available column in the active row.

THANK YOU FOR ANY HELP!!!!!!!!!!!!!!