Text to columns then back to single column

Question

Hello, please see attached output from my current Alteryx workflow.  I have completed a text to columns tool to breakout the multiple subject referenced in col C and you can see the output of that in col H-I.

However what I need to do now is get back to a single column of subjects with the information on that given row duplicated.  I am unsure of the best way forward to accomplish that in Alteryx and appreciate all suggestions.

Current Data:

Project ID, Teacher ID, Subject, Subject Subcategory, Grade, Project Resource, Project Date, T2C Results 1, T2C Results 2

Need data in format:

Project ID, Teacher ID, Subject, Subject Subcategory, Grade, Project Resource, Project Date, T2C Results 1

Project ID, Teacher ID, Subject, Subject Subcategory, Grade, Project Resource, Project Date, T2C Results 2

Let me know if any questions and I appreciate the assist.

Output by subject.xlsx

Kenda · Accepted Answer

Hey @JGalle0121!

In your Text to Columns tool, I would suggest using the 'Split to Rows' option instead of breaking it into separate fields then trying to make new rows. You will likely have to get rid of extra white space, but this should get you the output you're looking for.

ponraj · Accepted Answer

Hi,

You can use split to row option in text to column tool  to get the results in single column.  Attaching sample workflow.