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