Quote:
|
I’m not sure if there is other tool that can help performing deriving the result table out of the given table as shown in the screenshot below
|
OK. In attachment is a possible solution which uses defined Tables, Table formulas, hidden rows and columns, and named ranges. Result table is on sheet Report.
On SourceTable sheet, columns D:H, containing intermediate calculations, are hidden.
On Report sheet, columns A:B with intermediate formulas are hidden. As in defined Tables column headers can't be formulas, dummy headers were created, and according F2 values are displayed at top as single datarow of additional table (with headers hidden).