How to split a cell value into multiple rows using Alteryx?

[Venamma]

Hi Team,

I have an excel file which has the data as shown below. I would like to split the each value into a separate row, Can you please help me?

Domain	Roles
Finance	Senior Analyst Analyst Lead
Audit	Manager Senior Analyst Analyst

Required Output:

Domain	Roles
Finance	Senior Analyst
Finance	Analyst
Finance	Lead
Audit	Manager
Audit	Senior Analyst
Audit	Analyst

[DataNath · Accepted solution]

Hey @Venamma if you use the Text to Columns tool, in 'Split to Rows' mode, that'll work. You just need to set the delimiter to \n which is the notation for a line break.

[Venamma]

This is helpful.
Thank you very much!