need solution for merging multiple items into one item

Summary:

need solution for merging multiple items into one item

Content (please ensure you mask any confidential information):

Hi guys, is there any solution of merging duplicate items into one item?

Making duplicate item Inactive will have a huge impact on existing onhand balance, inbound shipments, inventory ageing etc.

Business is looking for some solution that will help to merge/ group duplicates into single item without disturbing existing inventory balances. Any suggestions please?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):