I have about 40 spreadsheets in the following format which I need to import.
I can write some VBA stuff but id like to do this in QV. I think Ill need some kind of Crosstable notion but Im not sure.
|Description||Age||Q1||Sales||Staff||Q2||Sales||Staff||Q3||Sales ... ...|
and I need something like
The Q1/Q2 columns in my data were just sum(Sales+Staff) and so I dont need it.
I've tried various rotations and things and not got too far. Any ideas? Ideally something step by step
Attached is a skeleton of my data