automate unmerging of cells

**JonPugh** · 07-19-2011, 06:07 AM

I have been sent a report that is generated by a third party application. The report is exported to excel but already with merged cells to show groupings. I need to be able to remove the groupings and have each merged cell show the data.

The attachment shows an example of what I get provided and what I need. I currently have to unmerge and copy which is a time consuming effort on a very large spreadsheet.

We have approached the supplier of the system to do a custom report but they have said they do not support any new developments on an old system. They only maintain it 'as is'!

Can anybody advise how I can do this within excel?

Thanks in advance.

Jonathan

**Azam Ali** · 07-19-2011, 06:27 AM

Hi JonPugh

find the formula in attatched file

**Azam Ali** · 07-19-2011, 06:34 AM

Hi JonPugh

look another way of doing it in enclosed file.

**JonPugh** · 07-19-2011, 06:41 AM

Hi Azam Ali,

Thanks for looking at this. Both solutions work great.

JonPugh

**Azam Ali** · 07-19-2011, 07:15 AM

it is nice that it is working for you

If your problem is solved, mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.