How to concatenate two records (rows) into a single record (row)

[JGalle0121]

Please see attached.  I currently have this output summarized by all the applicable fields you see.

The first two are duplicate (teacher ID and date) for multiple rows: I am trying to determine which resources are commonly requested together and so my output thus far has resulted in multiple rows per teacher, date.

What I would like to do is take the 2-5 rows per teacher/date and concatenate the resource category into a single record/row by teacher ID/date (i.e. Supplies, Technology) vs Supplies in one row and Technology in the next row.

I tried using a Crosstab tool without success, but maybe I'm just missing something.

Appreciate the help!

[JGalle0121]

Here's my current workflow as well.

[BenMoss · Accepted solution]

Check out the summerize tool. Group by your variables you want as columns then use the concatenation function on the field you wish to collapse into a single cell.

Ben

[MarqueeCrew]

@BenMoss,

I've offered @JGalle0121 a private webex session if he/she is available to review their challenge.  In looking at the data, there is more than meets the eye in the requirements.

Cheers,

Mark

[JGalle0121]

Thanks @BenMoss!  This worked perfectly, I added some additional functionality as well to get common concatenations across the board.  I've given you a star for feedback, appreciate the assist.

@MarqueeCrew Thanks for offering to WebEx, that's extremely generous of you.  I've given you a star for feedback as well :)

[MarqueeCrew]

@JGalle0121,

Thanks for the star :)

I think that you will also find that your combination of resources will be a challenge.  There are examples where the resources for a given teacher/date combination include duplicates of the resource (e.g. Books, Books, Supplies).  I don't know how you want to handle these occurrences, but think that you might want to use a UNIQUE tool prior to the summarize tool where you group by teacher, date, resource.

Cheers,

Mark