I'm working on creating a card that feeds from our data set of activities. Each activity has a status (1,2,3,4,5) and is tied to an individual client.
The table produces a result similiar to this:
| Activity 1 | Activity 2 | Activity 3 | Activity 4 | Activity 5 |
Client A | Completed | | | | |
Client A | | Completed | | | |
Client A | | | Not Completed | | |
Client A | | | | Not Completed | |
Client A | | | | | Not Completed |
Client B | Completed | | | | |
Client B | | Completed | | | |
Client B | | | Completed | | |
Client B | | | | Completed | |
Client B | | | | | Completed |
How can I merge the information so all client activity results are populated on one line? Would this require a beastmode or is there another option that I am missing?
Thanks,