SOLVED
Repeat items and delete subtotals
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
MiroPwC
7 - Meteor
‎10-17-2020
01:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey guys,
I would like to ask you for your help with part of my flow.. I am sending you excel where you have 2 sheets.. First one consists of raw data. The point is to repeat Account number for all blanks above the row with account number and then delete this subtotal row. You can see desired output in the second sheet, where the selected account number will be in each relevant row + the subtotal row is deleted.
May I ask you for help with this as I have never experienced something like this.
Thanks a lot.
Solved! Go to Solution.
Labels:
- Labels:
- Custom Tools
- Data Investigation
- Help
2 REPLIES 2
17 - Castor
‎10-17-2020
02:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MiroPwC I mocked up a workflow that produces your desired output let me know what you think?
‎10-17-2020
03:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Works like magic 🙂 Thanks a lot
