How to insert multiple column values into one column in a specified manner

[Gsiva3]

Hi Team,

I have an input with columns named as Target,Column1,Column2,Column3,Column4 & Column5.

My desired output is I want to populate all the Column1,Column2,Column3,Column4 & Column5 values into Target column.

Tried few tool but not able to get the desired output.

Please help me on this.

Attached the sample input and desired Output.

[IraWatt · Accepted solution]

Hey @Gsiva3,

I see you have two sheets with inputs and desired outputs. For your second sheet you can do something like this to pivot the data:

Any questions or issues please ask :)
HTH!
Ira

[IraWatt · Accepted solution]

@Gsiva3 I dont know if this is an error but here column 4 is referencing the column above.

Otherwise you can replicate this Excel formula with Alteryx's Substring formula:

[Gsiva3]

Hi @IraWatt 

The first solution is what I have expected.

Its working fine!!

Thank you so much @IraWatt 

[IraWatt]

Awesome 😄 no worries @Gsiva3 !