Good Morning,
I have a report I pull that has a basic data structure of the table below. I have masked and simplified the data.
<tbody>
ID
Sub_ID
User
Role
1
A
Person1
Supervisor
1
A
Person2
Analyst
1
B
Person3
Assistant
2
C
Person4
Supervisor
2
C
Person5
Analyst
2
C
Person6...