Something like this?
I added a column for numbering rows into source table, and removed spaces from 2 column names there. And placed the result table on separate sheet.
On sheet with result table, I moved dates to Named Range at top of sheet, and added non-formula headers to result table, which allowed the result table to be defined as Table too.
|