Seperation

[ntudev]

Hello,

How do i separate the info tab? i need it to look like the 

Date	Info
9/30/2022	CLEAN, DIRTY

i need it to look like the 

Date	Info
9/30/2022	CLEAN
9/30/2022	DIRTY

[Kakuffo]

hi @ntudev  theText to columns tool would be the one. use the split to rows option and specify the delimer as a comma
Update -added workflow

[Sarreddy · Accepted solution]

@ntudev 

Can you try like this.

[ShankerV]

Hi @ntudev 

Please find the solution 

Many thanks

Shanker V

Step 1: Input

Stpe2: 

Stpe3: 

Stpe4: 

Kindly accept this solution if it provided a solution to your question.

[OllieClarke]

@ShankerV , @Sarreddy as @Kakuffo showed, the Text to columns tool can also parse text to rows. so no need for transposing, or RegEx :)