Phil Parkin - Thursday, January 19, 2017 10:55 AM
Haven't run into the "formatted as Accounting" problem before. I'll have to give that a try.
Agreed on the second part about mixed columns but I've beat that particular problem without a registry hack by reading in the column names as data along with the rest of the rows. It's necessary to figure out how to auto-magically unpivot like-data across, say, multiple months and to also auto-magically capture the column names without duplication for the final result. If they add another month or even a set of totals for a quarter/year, the code auto-magically figures all that out with no prior knowledge on the part of humans. It's totally "PFM2". 😉
--Jeff Moden
Change is inevitable... Change for the better is not.