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

Question

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.

Sample Input & required Output -.xlsx

IraWatt · Accepted Answer

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 Answer

@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: