This seemed to work for me though, to be honest, there were only values and no formulae.

First, expand all the groups.
Select Cell A1
Press Ctrl-Shift_End to select all the cells
Press Copy
Press Paste Special | Values
Press Paste Special | Formats

Done.

I can still expand the groups down and across so, hopefully, you can too.


Regards