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
Enter your details below to receive your free spreadsheet.
Another Free Spreadsheet by XLAutomation.
If you found this spreadsheet helpful please make a donation.
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.