Welcome! This forum has a treasure trove of great info – Scouters helping Scouters! Just a heads up, though - all content, information, and opinions shared on this forum are those of the author, not the BSA.
I am a Unit Admin for both my Troop and Pack. I am trying to run a roster for just the Pack. In Roster Builder, I have Leaders and All Scouts selected under the Pack, and nothing selected under the Troop.
The resulting report lists both the Troop and Pack at the top, and if the Pack adult is also registered in the Troop, they appear on the report twice, once with their Pack position, and again with their Troop position.
@ZacharyMcCarty I did some experimenting. At the top, under Sort by, if I choose “Den/Patrol, Last Name, First Name, then Middle Name”, it lists dual-registered adults twice, one line for each unit. If I change the Sort by to “Last Name, First Name, then Middle Name”, then the dual-registered adults are only listed once, but both units and positions are shown. URLs to both are below.