Adding a row with a specific value

[jh105109]

Hi all,

I am working on a file where I have a row with a company name, and within the company name is a company number. The company name is currently on row 1, but I want to have a row below the company name that is just the company number. Does anyone have any recommendations for the best way to do this in Alteryx? I provided visuals below:

Below is my input data:

Below shows the row that I want to add:

[jdunkerley79 · Accepted solution]

Try the attached.

Uses a multi-field formula tool to get the account numbers out and then unions to original data.

[jdunkerley79]

Dupe

[jh105109]

Thank you!