How to merge content?

When duplicate or overlapping content is created, there can be a need to consolidate it.

We'd want to pick one of them as canonical, move it's content into the other, delete or unpublish it, and create a redirect.