Cross tab with Multiple data values.

[ggangi]

I have the following data set and would like to cross tab by the field name JurisdictionType.  If I Crossed tabbed by the values of the filed there would be an extreme amount of columns that are not needed.

Below is a sample of the data

Thanks in advance.

[FrederikE]

Hey @ggangi,

What seems to be the problem? Such a Cross tab is able to do this, depending on your input you might also want to use the "Group" option on Documentcode: 

[cjaneczko]

Try this.

[geraldo]

@ggangi 

AN WORKFLOW EXAMPLE

[albert_alaluf]

Hello @ggangi 

Please see my response.

[ggangi]

Thank you that worked perfectly!