Embedded newlines in multiple cells

[Tbuff]

My data has multiple cells with embedded newlines in the example below.

I need to split each newline into a separate row so that the output looks like this -

I have tried the Text to Column tool with \n to split into rows and have also tried Regex to replace the \n with a delimiter, then a Text to Column tool to split each of the columns into rows. Both of these methods produce an output with duplicated records.

Any help would be greatly appreciated.

Thanks,

Tony

[Luke_C · Accepted solution]

Hi @Tbuff 

Here's an example of this, you're on the right track with text to columns.

1. I filtered out the empty records then transposed the data
2. Then I did text to rows on the one column containing the values
3. I used the tile tool to associate the different fields together
4. Crosstabbed the data back

[fmvizcaino]

Hi @Tbuff ,

Here it is.

Best,

Fernando Vizcaino

[atcodedog05]

Hi @Tbuff 

Here is my take on it. I am splitting them separately and joining them.

Workflow:

Hope this helps : )

[Tbuff]

Thanks for all the help with this! All of your solutions resolved my issue.