Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Taking duplicates of Rows in excel based on First column

SahadhKuruniyan
8 - Asteroid

Hi Team,

 

I am new to excel and I need to split rows based on Team column, 

 

TeamControlstatus
A,B1Good
C2Okay
A,B3Good
B4Good

 

I need to convert like below:

 

TeamControlstatus
A1Good
B1Good
C2Okay
A3Good
B3Good
B4Good
1 REPLY 1
binuacs
21 - Polaris

@SahadhKuruniyan One way of doing this

image.png

Labels
Top Solution Authors