Finding Multiple Values for same ID then add new column with label

[rockeylearning]

Hi Community!

I having trouble putting this together

 below is the table I got after did the Summarize grouping

ID	Field_15
35050
35050	CorpC
35050	web
35050
36175	web
36175

I need to find if the ID have both CorpC and web from Field_15, if so then in the new field add the value Corpweb, else if ID only has one web in the Field_15 then add 'web"

ID	Field_15	New Field
35050		CorpCweb
35050	CorpC	CorpCweb
35050	web	CorpCweb
35050		CorpCweb
36175	web	web
36175		web

How can I accomplish this?

any help is greatly appreciated.

[TimN · Accepted solution]

Something like this.  In my Summary tool note that I removed the delimiter.

[rockeylearning]

@TimN THANK YOU! you're awesome! this worked.