Adjust number and extract data down

[YRichardson12]

Hi, I have data in the first row that needs to be broken down (extracted down) to additional rows based on the number in row 1 column Inst 1 (the # 3), is there a way to do this in Alteryx? See image for reference. I had to a concatenate to bring in my data to show the types of Inst Type 1 I had and Businesses,

but now I need to pull them down to get a true count. Help and thank you!

[atcodedog05]

Hi @YRichardson12 

Here is how you can do it.

Workflow:

Hope this helps : )

[YRichardson12]

@atcodeog05 - almost...The column Inst 1 is reflecting all the instructors I have. So really I have 2 Strategic Associates and 1 Training Partner, in total 3. I need to get the column numbers corrected and the names in the last two columns down. Is this possible? The attached picture is what I am trying to get to.

 

[atcodedog05]

Hi @YRichardson12 

Sorry its not completely clear to me.

[YRichardson12]

Sorry. I attached another image to show what I need. Column SA Inst is showing 3, but really this is reflecting for 2 SA's (Strategic Associate) and 1 TP (Training Partner). I need it broken down to correct the SA Inst column and continue to leave the 1 in the TP Inst column. 

Thanks anyways for trying! Much appreciated.

 

[atcodedog05 · Accepted solution]

Hi @YRichardson12 

Are you looking for something like this

Hope this helps : )

[atcodedog05]

Happy to help : ) @YRichardson12 

Cheers and have a nice day!