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

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.

Split roles to rows.yxmd