Your 'Go To' for Custom Excel Solutions

Unmerge and Duplicate

Another free spreadsheet from the XLAutomation development team. This one demonstrates a method to overcome the issue of merged cells and reporting.

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

Download Your Unmerge & Duplicate

We will use the details entered below to add you to our mailing list to receive the free download file and latest news about free spreadsheets and products from the XLAutomation team. You will have the option to unsubscribe at any time. 

Another Free Spreadsheet by XLAutomation.

If you found this spreadsheet helpful please make a donation.

Tell us what you think...

Thanks to the trading community who have downloaded our spreadsheet. We would love to know how useful you've found this solution, and if you think we could include anything else to make it even better! Leave a comment and let us know.


  1. Hannah Lindsay on October 2, 2017 at 10:48 pm

    Testing the the comments from Hannah’s account.
    She got the notification I did not

  2. Scott Lindsay on October 2, 2017 at 7:43 pm

    Test of comments ready for new plug-in

  3. ben32leeton on October 2, 2017 at 1:18 am

    and another comment on my own

  4. Scott Lindsay on October 2, 2017 at 1:07 am

    This will be a test for our work on comments

    • ben32leeton on October 2, 2017 at 1:17 am

      Ok this is one thing that will be useful

  5. Scott Lindsay on August 19, 2017 at 9:47 pm

    This was the first free spreadsheet we provided our website visitors and can be really useful when converting a merged set of data into a reporting source for analysis

Leave a Comment