Pulling together distinct values from several columns

Hi,

I am new to this forum, would need your advise

I have a large worksheet analysing different data flows loading into a sytem. I have analysed each flow and captured the fields populated in the flow.

A small example is in the attached.

Could someone please advise how can I:
1) have a column containing all the UNIQUE fields imported into the system and
2) a tick (or Yes or Y) adjacent to the flow column indicating the field included...it is hard to explain, in theory I want to go from:

distinct columns.jpg


Please let me know if my question is not clear

Many Thanks
Asif