Backport PR #36927: BUG: Fix duplicates in intersection of multiindexes
Backport PR #36927
@phofl can you give this a quick once over before I merge since there were several merge conflicts to resolve, where I could have gone wrong. Looks good. Should cover everything. Thanks @phofl 