Hi,
I'm currently facing bottleneck with my workflow and hope you guys can lend me a hand. High level understanding, my workbook contains 500 tabs with identical data and I'm trying to consolidate all the tabs with 'dynamic input' tool and perform subsequent reconciliation work.
The following is example of data:
| Price | |
| Product A | |
| Product B | |
| Product C | |
| Product D | |
| | |
| Design | |
| A | |
| B | |
| C | |
| D | |
| | |
| Payment | |
| Credit Card | |
| Cash | |
| | |
| Volume | |
| Product A | |
| Product B | |
| Product C | |
| Product D | |
After consolidate the data from 500 tabs with dynamic input tool, I would like to remove all the rows corresponding to Volume- Product A,B,C,D. I have considered to use the following tools:
a. Filter tool- not suitable because I want to keep rows corresponding to Price- Product A,B,CD
b. Unique tool + Record ID tool + Filter tool - not suitable because there are more than 10k rows after I consolidate the data with dynamic input tool,
c. Cross-tab- not suitable because again, it has more than 10k rows
Note: I tried to use excel and perform bulk rows removal by coping all the tabs. However, the rows associated to Volume -Product A,B,C,D are not consistent across the workbook and this is not feasible too.
Do you guys have any recommendation?
