Code
Build a staff directory
One source of truth from three exports that disagree.
Fill it in
HR, seating, and whatever else.
And show which source won.
From reporting lines, with the gaps flagged.
Your prompt
Build one directory from . The sources WILL disagree: someone left in one and not another, two spellings of a team, a seating list from before the move. Reconcile explicitly and show which source won for each conflict, because a directory that silently picks is one nobody can correct. Match people on something stable. Names collide and change, so use the work email where there is one and flag the rest. Draw the org chart from reporting lines and flag the gaps: people with no manager, circular lines, and a manager who left. Those are the actual findings. Searchable by name, team, role and location. One self-contained page, with no personal contact details beyond the work ones.
Continue and pick your folderOpens with everything above already filled in.
Why this works
Three people exports always disagree, and a directory that silently picks a winner is one nobody can correct. This shows which source won each conflict, matches on something stable, and flags the org-chart gaps, which are the actual findings.