Hello, How do i separate the info tab? i need it to look like the DateInfo9/30/2022CLEAN, DIRTY i need it to look like the DateInfo9/30/2022CLEAN9/30/2022DIRTY

Seperation

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

@ntudev

Can you try like this.

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

@ntudev

Can you try like this.

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.

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