Rearranging Data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
- Labels:
- Alteryx Practice
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is the data in excel format.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @mot,
Thank you for suggesting the solution so fast. I greatly appreciate your help. Best Regards!
