Line Break with Concatenated Data

[ryanmor24]

So I have a list of employee names, IDs, and Job titles that are associated with Supervisors. I have concatenated the information to group employees by supervisor and have a single cell with "Name, Title (ID), Name2, Title2 (ID2) ..." I want to have each of those employees' information on separate lines in a singular cell. How would I do that? 

[mceleavey]

Hi @ryanmor24 ,

can you please post some mock data and a mock outcome showing what you're trying to achieve?

M.

[Maskell_Rascal · Accepted solution]

Hi @ryanmor24 

If you're using the Summarize tool to concatenate your results together, you can use a '\n' separator to signal that you want each record on a new line. 

Sample Data:

Output:

If this solves your issue please mark answer as correct, if not let me know!

Thanks!
Phil

[Thableaus]

Hi @ryanmor24 

How does the data look like concatenated? Is it with commas (,)?

Depending on how this looks like you could just replace commas with line breaks using REGEX

REGEX_Replace([Field], ",", "\n")

Cheers,