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]

Hi @olpako ,

I would love to help but it would be great if you share these in excel sheet instead of screenshots as it is difficult to reproduce all the data. Also, could you re-post under discussions/Designer? Best.

[olpako]

Here is the data in excel format.

[mot]

Hi @olpako ,

See the attached workflow.

I hope this helps. Best.

[olpako]

Hi @mot,

Thank you for suggesting the solution so fast. I greatly appreciate your help. Best Regards!