Hi all,
I am trying to output a table into multiple tabs after removing null columns.
Example input:
| Entity | Sub 0 | Sub 1 | Sub 2 | Sub 3 |
A | 100 | 200 | | 400 |
| B | 300 | | 300 | |
| C | | | | 200 |
Te output excel would have the three tabs with following differenct tables:
Tab A
| Entity | Sub 0 | Sub 1 | Sub 3 |
A | 100 | 200 | 400 |
Tab B
Tab C
I am currently using a batch macro that filters the "Entity" and runs a crew macro that removes null columns. This then has an output tool that takes file name from the "Entity" column
Problem: The output file does have three different tabs, with just relevant rows, but it outputs all the columns, including the empty ones. I have searched everywhere to try and resolve this issue, I really hope you guys will be able to help!
