Bifurcation between of various transactions type within one excel sheet.
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
B_bhatta
7 - Meteor
‎11-03-2020
09:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you please me modify my "Sheet 1" tab dataset into the "Desired output" tab format. Thanks a lot!
Labels:
- Labels:
- Developer Tools
5 REPLIES 5
mbarone
16 - Nebula
‎11-03-2020
09:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
While we won't do the work for you, I can suggest that you familiarize yourself with the Filter Tool & Union Tool.
‎11-03-2020
09:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have used the filter tool and but when i bring together both nodes, I am not being able to get a space between the segregation. Hence, need some guidance.
mbarone
16 - Nebula
‎11-03-2020
09:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use a Text Input tool to create however many "blank" rows you need and union that in as well.
‎11-03-2020
09:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much. I will follow that approach 😊
mbarone
16 - Nebula
‎11-03-2020
09:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Welcome!