Concatenate multiple data rows - Please help!!!

[sagar_agarwal]

Hello All - I need some help figuring out in what I think is really challenging. I need to concatenate the "Menu Path" symbol present in different rows based on the value of "Symbol". Please refer to below screenshot which is a sample of what I want.

[Federica_FF · Accepted solution]

Hi,

you can use a Summarize tool. Group by Symbol - Menù Path, go in the category Strings and choose "Concatenate", setting comma+space as delimiter

[sagar_agarwal]

This worked like charm - thank you so much!

[neeleshapatil1]

Is there any limitation on the size of concatenated string? How to overcome such limitation in case of too long string exceeding size limit?