Rearranging Data

[olpako]

Below are the screenshots of what I am trying to do. I have a list of orders with Party1...[n] listed in rows with corresponding Counterparty 1...[n] listed below each individual Party. I need to move rows with Party to a column next to the corresponding Counterparty and remove Sum rows after each separate Counterparty.

Thank you for you help! 

Have:                                                                                                                  

Need:

[mot · Accepted solution]

Hi @olpako ,

Please see attached.

I hope this helps. Best.

[Qiu · Accepted solution]

@olpako 
A bit different approach.

[olpako]

@Qiu

Thank you for your solution! This community rocks! I am new to Alteryx and having access to this group is extremely helpful. Thanks a lot.

[olpako]

Hi @mot,

Thank you for providing the solution! This is really helpful, I greatly appreciate your fast response. Thanks a lot! 

[Qiu]

@olpako 
Glad to help and thank you for the accept mark.😁