hi folks,
i have a tableau of data in cross-tab format / layout. this layout is fixed because it is a data dump from another system.
now, i need to generate a report on that data, for which i would like to utilise Pivot Tables.
i have attached a sample excel workbook illustrating the as-is and to-be layouts.
i have provided some explanation / information within the file.
i am open to using helper columns / tabs, but not VBA.
please let me know if there is need for further clarification on any aspect.
thanks in advance.
Bookmarks