Support non unique period indexes on join and merge operations
 - [x] closes #16871
 - [x] tests added / passed
 - [x] passes ``git diff upstream/master -u -- "*.py" | flake8 --diff``
 - [x] whatsnew entry

Now join and merge operations on dataframes with non unique period indexes are supported, test included.