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