How to move data from one row to another

[abardaje]

What I want is to move the amount from "Child" row  all to the "mother" row if they have the same Parent Alias. Please see the attached as reference. thank you!

[VijayAnaparthi · Accepted solution]

Hi, PFA of Workflow and Output.

[abardaje]

I have another question, if you don't mind, do you know how to merge those who have the same "Parent Alias" into one cell? they will merge into one cell or if there's no functionality like that in Alteryx is there any workaround to do that to merge all the same value(Parent alias) in one cell? 

Attached is the sample output I want in Alteryx. 

[binuacs · Accepted solution]

@abardaje one way of doing the merge using the Table tool

[abardaje]

My issue has been resolved. Thank you all! :)