I have already looked all over internet and have not manage to find any answer to fit my question.
I am trying to create this for the past 5 months with no result and no help in general.
Yes I have posted this question on another forum, but have not received any help for the past 5 months.
My problem is that I have this set of data on sheet1
1651097564166.png
And I want to concatenate the IDs, Targets and DNS based on Name and Risk on Sheet2 like this
So if it has the same name eg: "Generic IWP" and different risks to categorize it differently
But if it has the same name eg: "Traceroute" and same risks to concat it as it shows.
1651098045033.png
Thank you in advance.
Bookmarks