Dynamically Turning Multiple Columns into one Column

[dlesny]

Hi

How to append data from multiple columns into one dynamically?

I have the following excel: Dynamically dependent on how many tasks under story the number of Columns increases _0_, _1_, _2_... but its always the same amount of columns for each task like here 3.

Story_FormattedID	Story_PortfolioItem	Task_0_FormattedID	Task_0_Iteration	Task_0_Owner	Task_1_FormattedID	Task_1_Iteration	Task_1_Owner
US1	Form Teams	TA1	ITR1	John	TA2	ITR1	Alex
US2	Backlog	TA4	ITR5	Paul	TA2	ITR4	Steve

How can I change it to this please:

Story_FormattedID	Story_PortfolioItem	Task FormattedID	Task Iteration	Task Owner
US1	Form Teams	TA1	ITR1	John
US1	Form Teams	TA2	ITR1	Alex
US2	Backlog	TA3	ITR5	Paul
US2	Backlog	TA4	ITR5	Steve

[jamielaird · Accepted solution]

Hi @dlesny 

The attached workflow should give the result you are looking for. Let me know if you have any questions at all.

-----
If I've solved your problem please consider marking this solution as accepted. Thank you!

[afv2688 · Accepted solution]

Hi @dlesny ,

Here you go

Cheers

[dlesny]

Awesome, Thank you