I've been having a heck of a time wrangling certain complex views in Drupal 10 and it's driving me up the wall. I'm a solo dev, so have been really banging my head off the wall on this. I don't really expect anyone to be able to solve this for me, but I just wanted to ask if there's anywhere that actually walks through more than basic Views problems? I've looked on YouTube and often found really simple examples, but nothing that unravels multi-layer complexity.

My use case is

- Content type called Resources

- A field within that page to reference a taxonomy called Contributors

- Contributors points to a Content type called Profiles, or a taxonomy page of Resources should they not have a full Profile

- I want to show a block with photo, name, title and link to the relevant profile/taxonomy page. I'm using Fields to pull this together, then outputting custom HTML

- I can get all the relevant Contributors to show up, but some show up in triplicate.

The issue seems to be something to do with Relationships in the View, but I for the life of me can't figure it out. I feel like I need to better understand just what Relationships and Contextual Filters are actually doing and why they would be showing multiple results. But I don't even know where to look to fill this knowledge gap. I've tried various AI chatbot solutions and they often muddle the issue way more than anything.

Edit: It looks like my solution was turning on Aggregation, then choosing Group by Entity ID in my Fields and it got rid of the duplicates.