Splitting columns

[ssubramanian]

Hi,

I have a requirement:

Input: 

Segment	LB	Dept
S1,S2	L1	D1,D2,D3
S2,S3	L2,L3	D4

Output: 

Segment	LB	Dept
S1	L1	D1
S1	L1	D2
S1	L1	D3
S2	L1	D1
S2	L1	D2
S2	L1	D3
S2	L2	D4
S2	L3	D4
S3	L2	D4
S3	L3	D4

This is just an example I have 7 such columns with different combinations. Right now I am using text to column tool for each of the 7 columns (7 Text to Column tools). Is there a way to do this in fewer steps?

[DavidP · Accepted solution]

Have a look at the attached files and see if you can open them in your Alteryx ( I changed the version to 2018.1). If you put both files in the same folder and run split cells.yxmd, it should work.

If not, I'll write up step by step instructions on recreating the i

[DavidP]

iterative macro

[ssubramanian]

Thanks a lot @DavidP. This is exactly what I wanted. Thank you so much!