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.
Solved! Go to 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
@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:
Awesome 😄 no worries @Gsiva3 !