How can i group and create a new field question

Question

I have a contribution file where 1 person with a specific id (CONTRIBID) has many different types of contributions (Source). I want to create a field that combines all the different [Source] into one field.

So in the example below Ryan James has 3 different types of  [Source] - DM, TM and DMURL.

I want to somehow group the [Source] by [ContribID] and create a new field called [CHANNEL].

Any thought on the best way of doing this? I'm still very much a newbie and appreciate any help. Thanks. Javier

HOW DO I CREATE THIS FIELD?CONTRIBIDNAMESOURCE CHANNEL123RYAN JAMESDM DM / TM / DMURL123RYAN JAMESTM DM / TM / DMURL123RYAN JAMESDM DM / TM / DMURL123RYAN JAMESDMURL DM / TM / DMURL234ANITA SMITHTM TM / DMURL234ANITA SMITHTM TM / DMURL234ANITA SMITHTM TM / DMURL234ANITA SMITHDMURL TM / DMURL456DONNA ELLETDM DM / TM456DONNA ELLETTM DM / TM456DONNA ELLETTM DM / TM456DONNA ELLETTM DM / TM

fmvizcaino · Accepted Answer

Hi @jdelaguila ,

I'm attaching a solution where I'm using 2 summarize tools to get all distinct sources for each ID.

Take a look and let me know if you need further help.

Best,

Fernando Vizcaino