Im not even sure this is possible.
I have a data set that is pulled into a excel spread sheet and pivoted as below.
orders and values are group along the top for currency (GBP), Code (E), Group (Austin), Year(2010), Month (10) and split by sales date (row labels). obviously there are many different groups, codes, year, month which stretch along the top.
im wanting to replicate this into a staging table, is this possible. i looked at pivot but it only seems to work with one grouping?
all help appreciated