is something like this possible in the straight table?
Table has 2 rows as header, first row has merged cells.
Sorry now picture attached
Yep. Can take a bit of work though.
Watch the recorded session
It also has files available and especially the excel sheet will be interesting.
Why the href you gave cant be accessed?
Why you did not use Pivot table. you will achieve through . Will save your time & nothing to do with formula for each column in this case.
Try with pivot table
You can hide title in table and create Text Object as per sample
Retrieving data ...