Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
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 ... ... |
|---|---|---|---|---|---|---|---|---|---|
| Leeds | 2 | 4554 | 323 | 2323 | 4343 | 7676 | |||
| London | 3 | 446 | 434 | 5454 | 2323 | 7676 |
and I need something like
| Description | Age | Quarter | Sales | Staff | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
Leeds | 2 | 1 | 4554 | 323 | ||||||
| Leeds | 2 | 2 | 2323 | 4343 | ||||||
| Leeds | 2 | 3 | 7676 | |||||||
| London | 3 | 1 | 446 | 434 | ||||||
| London | 3 | 2 | 5454 | 2323 | ||||||
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