I need to create separate outputs per ID. But before I do that, I need to remove all the columns with null values, which is different for each row. A colleague shared a batch macro to use for the data cleansing, but it's not working and I'm not sure how to fix it.
Current:
| Product | ID | Timestamp1 | Prev Identifier | Market | Venue |
| A | 123456 | Null | -1 | 101 | Null |
| B | 234567 | 2021-07-07 | Null | ABCD | Null |
| B | 234567 | 2021-07-07 | Null | ABCD | Null |
Desired:
Output 1
| Product | ID | Prev Identifier | Market |
| A | 123456 | -1 | 101 |
Output 2
| Product | ID | Timestamp1 | Market |
| B | 234567 | 2021-07-07 | ABCD |
| B | 234567 | 2021-07-07 | ABCD |
