creating a Pivot Table out of data in a cross-tab tableau

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.

Hey Ice,

I've been looking at Cross Tab tables for years and finally created VBA code to convert them to Excel Type Tables so I could do Pivots on them.

First - Sorry I have a VBA answer..
Second - This VBA code will work for a lot of different formats of cross tab tables.

See the attached. Hope it helps, even though you didn't want any VBA. You do need to convert the data to a normal excel table somehow and I think VBA is the path to follow.

hi marvin,

thanks for your response to this thread.

let me take a look at your file and figure out my forward.

best regards...