I have some information which is currently sorted by team number (5 in total) and execution number.
Each execution has 4 properties, Execution, Segment, Month and Duration. I need to resort the data by team number and Segment.
Whilst I know how to do this in Access, my ability to do it in Excel is somewhat limited! I hope you can help
I can not change the source data.
Here's how it looks now...
and this is how I want it to look:
Each execution has 4 properties, Execution, Segment, Month and Duration. I need to resort the data by team number and Segment.
Whilst I know how to do this in Access, my ability to do it in Excel is somewhat limited! I hope you can help
I can not change the source data.
Here's how it looks now...
test.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | ExecutionSummary | team1 | team2 | team3 | team4 | team5 | |||||
2 | Execution1 | ||||||||||
3 | Execution | TelevisionCommercial | Radio | TelevisionCommercial | TelevisionCommercial | TelevisionCommercial | |||||
4 | Segment | Aspirers | GrassRoots | Aspirers | Aspirers | Aspirers | |||||
5 | Month | Jun | Sep | Apr | Jan | Jun | |||||
6 | Duration | 1 | 2 | 2 | 3 | 2 | |||||
7 | |||||||||||
8 | Execution2 | ||||||||||
9 | Execution | POSonshelfsignage | TelevisionCommercial | Digital | Radio | ||||||
10 | Segment | Supermarket | GrassRoots | Elites | Aspirers | GrassRoots | |||||
11 | Month | Oct | Oct | Jun | Jan | Jun | |||||
12 | Duration | 1 | 1 | 1 | 3 | 2 | |||||
13 | |||||||||||
14 | Execution3 | ||||||||||
15 | Execution | Cinema | TelevisionCommercial | BuyOneGetOneFree | 10%Off | Cinema | |||||
16 | Segment | Elites | Aspirers | ConvenienceStore | Supermarket | Elites | |||||
17 | Month | Sep | Sep | Feb | Jan | Jun | |||||
18 | Duration | 1 | 2 | 1 | 1 | 1 | |||||
19 | |||||||||||
20 | Execution4 | ||||||||||
21 | Execution | StoreStaffPromotion | Sponsorship | AdvertisingCustomerMagazine | ThreePacksforthePriceofTwo | ||||||
22 | Segment | Supermarket | Aspirers | Supermarket | Supermarket | GrassRoots | |||||
23 | Month | Oct | Oct | Jun | Sep | Jun | |||||
24 | Duration | 2 | 1 | 1 | 1 | 1 | |||||
Sheet1 |
and this is how I want it to look:
test.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
L | M | N | O | P | Q | R | S | |||
1 | Segment: | |||||||||
2 | 1 | 2 | 3 | 4 | 5 | |||||
3 | Aspirers | Execution | TelevisionCommercial | TelevisionCommercial | TelevisionCommercial | TelevisionCommercial | TelevisionCommercial | |||
4 | Month | Jun | Sep | Apr | Jan | Jun | ||||
5 | Duration | 1 | 2 | 2 | 3 | 2 | ||||
6 | Execution | Sponsorship | Digital | OutOfHome | ||||||
7 | Month | Oct | Jan | Jun | ||||||
8 | Duration | 1 | 3 | 1 | ||||||
9 | Execution | Digital | ||||||||
10 | Month | Oct | ||||||||
11 | Duration | 1 | ||||||||
12 | GrassRoots | Execution | Radio | Radio | ||||||
13 | Month | Sep | Jun | |||||||
14 | Duration | 2 | 2 | |||||||
15 | Execution | |||||||||
16 | Month | Oct | Jun | |||||||
17 | Duration | 1 | 1 | |||||||
Sheet1 |