How can i group and create a new field question

[jdelaguila]

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?
CONTRIBID	NAME	SOURCE		CHANNEL
123	RYAN JAMES	DM		DM / TM / DMURL
123	RYAN JAMES	TM		DM / TM / DMURL
123	RYAN JAMES	DM		DM / TM / DMURL
123	RYAN JAMES	DMURL		DM / TM / DMURL
234	ANITA SMITH	TM		TM / DMURL
234	ANITA SMITH	TM		TM / DMURL
234	ANITA SMITH	TM		TM / DMURL
234	ANITA SMITH	DMURL		TM / DMURL
456	DONNA ELLET	DM		DM / TM
456	DONNA ELLET	TM		DM / TM
456	DONNA ELLET	TM		DM / TM
456	DONNA ELLET	TM		DM / TM

[fmvizcaino · Accepted solution]

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

[jdelaguila]

Fernando! That's what i needed! Thank you so much!  

Javier