How to split multiple lines of data into a single individual line in splunk using \n?

[Shan]

As i mentioned below prod column has multiple values and i want to split it based on \n next line command and get the output as mentioned in output image.

Current data:

Expected output:

Thanks in advance ..

[ITWhisperer]

| eval Prod=split(Prod,"
")
| mvexpand Prod

[Shan]

@ITWhisperer 

Thanks for your input. But its not working .

[ITWhisperer]

The split has the newline in quotes - hint: use <shift><return> to insert into search

[Shan]

@ITWhisperer 

Sorry, I'm not able to follow you. Can you please give me an example query..

Thanks in advance ..

[ITWhisperer]

| eval Prod=split(Prod,"
")
| mvexpand Prod

If this is not working, can you share your search in the same way i.e. in a code block </>

[Shan · Accepted solution]

@ITWhisperer 

Thanks for your input . As i mentioned Split not helped me.
I can able to achieve what i expected with below solution.

| makemv tokenizer="([^\r\n]+)(\r\n)?" Prod
| mvexpand Prod

🙂