The logic is as such:
- Rows with “TRUE”,“N/A” need to be moved to a new data table.
- (Rows with the same 4th column are grouped) These should contain one “TRUE” for every unique ID in column 1 which then need to be moved to a new data table.
I’ve just about managed it with my code, however this requires me to create a new data table for every unique ID in column 4, which may not scale up very well.
Thankyou for your help,
As a new user I cannot attach my excel data or my code so I’ve uploaded them here.