Uncollapse Columns or Dynamic Pivot or ??
Greetings - I'm working on a Finance Dashboard and I've been given a data set in Excel that pulls metrics from various source files via a VLOOKUP; this is updated monthly with current month and year to date values. I can create most of the cards I need from this data, however, I need to calculate a new metric. The problem is the way the file is set up -- see snapshot below. The two metrics that I need to use to produce the new metric are in the same column -- C.
I need to produce the Outpatient discharges which is Adjusted Adm/Disch - DISCHARGES. I thought about an ETL using UNCOLLAPSE COLUMNS, but I have 431 monthly metrics. Any thoughts on how to best proceed?