Unmerge & Duplicate

This Free Spreadsheet provides a macro that you can use to unmerge cells and duplicate the data from the merged cells into each cell in that merged range. We developed this for a client that had hundreds of workbooks with merged data and saved them countless hours in reformatting those workbooks to access it for reporting.

It is particularly useful when you receive a spreadsheet that includes many merged cells that you want to convert and use in a pivot report. The starting point in this case had a number of different columns of data "merged". To prepare it for a reporting solution the merged cells needed to be "unmerged" and then the data duplicated ready for consolidation.

Here is the starting point

Now after the macro has been run we have the "merged" cells cleared and the data duplicated

Click on the "Download" button below to get a copy of this sample workbook. Use our Contact Form to let us know if you find Free Spreadsheet useful and any suggestions for improvement.

Download Unmerge and Duplicate

Note: This workbook has been tested on Windows running Office 2013. No testing on MAC has been performed. It may work for a MAC environment but will need to be verified by others.