Using the cross tab tool to add new columns from a string field.

Question

Hi -

I'm  trying to use the cross tab tool to add new columns from a string field. I'm having a hard time as the method of aggregations results on either only the first or last record to show. I need an updated table that has all the records.

My original table is the following (just one person of may on my table as an example (see table 1):

I'm trying to use the cross tab tool to create the following able (see table 2)

Is there any other tool that I can use to get this done?

table 1.PNG

table 2.PNG

binu_acs · Accepted Answer

@slopezd10  you need to group the Field before applying the Cross Tab

slopezd10 · Accepted Answer

Thanks. I applied this to a more complex scenario and worked pretty well.