Cross Tab

[LIOUJ]

Hi

I have a simple dataset that I'm trying to cross tab.  My original data looks like this: 

I'm trying to cross-tab ContenID into a single row with each values separated by a "|".  Outcome I'm after is this:

Can anyone help me?

[AkimasaKajitani]

Hi @LIOUJ 

You can use Summarize tool.

But before using it, you have to change the data type of "Content ID" field from Numeric to String.

Please check the attached workflow.

[messi007]

@LIOUJ,

You can use cross tab tool as well 

Attached the workflow.

Hope this helps!

Regards