Your 'Go To' for Custom Excel Solutions
excel-logo-white-175

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

Enter your details below to receive your free spreadsheet. 

Another Free Spreadsheet by XLAutomation.

If you found this spreadsheet helpful please make a donation.

promise

 

Our Promise: "We will only use your contact details to share the latest news, free spreadsheets and product information from the XLAutomation team. We will never share your contact details with anyone else.

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.

Leave a Comment





7 Comments

  1. Tim Nelson on October 3, 2017 at 8:58 am

    Just a test comment for the site

  2. 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

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

    Test of comments ready for new plug-in

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

    and another comment on my own

  5. 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

  6. 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