Summarize and Concatenate Data

[krishnagandhi]

I have data that is summarized by unit#, date & PO# what i am trying to do is when i have multiple PO's i am trying to output to a column that will list those PO's so i don't have so many lines. For example in the attachemnt all the highlighted rows show only show 1 row per unit number because the combination of unit num & start date is not unique.

Thanks!

[grossal · Accepted solution]

Hi @krishnagandhi,

use a Select-Tool in front of the Summarize to convert your PO-Number to a string. You can then use the following settings in the Summarize Tool:

Let me know if this is what you are looking for!

Best

Alex