Hi,
This seems simple but I can't get my head around how to do it as there seems to be too many options, none of which seem as simple as I think they should be - any solution will be greatly appreciated and received!
I am trying to split the data table below into groups according to the columns which have a "Y" in their rows.
| INPUT | | | |
| | | | |
| Activity Name | AM | B&P | BD |
| Course 1 | Y | Y | |
| Course 2 | Y | Y | |
| Course 3 | Y | | |
| Course 4 | Y | | Y |
| Course 5 | Y | | Y |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| DESIRED OUTPUT - 3 separate data streams/tables, as follows | | | |
| | | | |
| Capability | Activity Name | | |
| AM | Course 1 | | |
| AM | Course 2 | | |
| AM | Course 3 | | |
| AM | Course 4 | | |
| AM | Course 5 | | |
| | | | |
| Capability | Activity Name | | |
| B&P | Course 1 | | |
| B&P | Course 2 | | |
| | | | |
| | | | |
| Capability | Activity Name | | |
| BD | Course 4 | | |
| BD | Course 5 | | |
