Line Break with Concatenated Data

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?

Workflow

Datasets

Data Investigation

Accepted answers

Maskell_Rascal

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

All comments

mceleavey

Hi @ryanmor24 ,

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

Maskell_Rascal

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,

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703