Hi
I have the below data that I have for over 20 stores and want to have tables set up so that once the main data is updated all the relevant table will just update accordingly. I was trying to do this by using Pivot table but I cannot get the data to display the way I have been requested to lay it out
Below is the Data the way it currently is
And Below is how we want it to dispaly - Basically there will be a tab for eacg Tag ( there could be 50 of these) and I want each tags results filtered onto each tab like below
Appreciate any direction in the right path
I have the below data that I have for over 20 stores and want to have tables set up so that once the main data is updated all the relevant table will just update accordingly. I was trying to do this by using Pivot table but I cannot get the data to display the way I have been requested to lay it out
Below is the Data the way it currently is
Store 1 | Store 2 | |||||
Keyword | Search Volume | CURRENT | DIFFERENCE | CURRENT | DIFFERENCE | Tags |
Keyword 1 | 1000 | 16 | -4 | 63 | -14 | Tag 1 |
Keyword 2 | 900 | 14 | 0 | 0 | 0 | Tag 2 |
Keyword 3 | 900 | 4 | 0 | 17 | 0 | Tag 4 |
Keyword 4 | 800 | 16 | 1 | 48 | -4 | Tag 3 |
Keyword 5 | 700 | 5 | 0 | 11 | -1 | Tag 1 |
Keyword 6 | 700 | 29 | -7 | 0 | 0 | Tag 2 |
Keyword 7 | 700 | 4 | 0 | 37 | -5 | Tag 6 |
Keyword 8 | 700 | 3 | 1 | 69 | -6 | Tag 1 |
Keyword 9 | 600 | 27 | -2 | 11 | 3 | Tag 7 |
Keyword 10 | 600 | 2 | 1 | 19 | 35 | Tag 8 |
Keyword 11 | 600 | 4 | 0 | 15 | 4 | Tag 1 |
Keyword 12 | 600 | 29 | -5 | 0 | 0 | Tag 3 |
Keyword 13 | 600 | 1 | 3 | 60 | 2 | Tag 4 |
Keyword 14 | 600 | 1 | 0 | 15 | 2 | Tag 1 |
Keyword 15 | 600 | 41 | 59 | 0 | 0 | Tag 5 |
Keyword 16 | 600 | 3 | -1 | 26 | -1 | Tag 9 |
Keyword 17 | 600 | 1 | 0 | 21 | 3 | Tag 1 |
Keyword 18 | 600 | 17 | -1 | 14 | 0 | Tag 1 |
Keyword 19 | 500 | 7 | -1 | 2 | -1 | Tag 5 |
Keyword 20 | 500 | 16 | -1 | 17 | 2 | Tag 1 |
Keyword 21 | 500 | 8 | 0 | 3 | 0 | Tag 1 |
Keyword 22 | 500 | 9 | -3 | 1 | 1 | Tag 1 |
Keyword 23 | 500 | 1 | 1 | 13 | 7 | Tag 3 |
Keyword 24 | 500 | 17 | 0 | 23 | 0 | Tag 3 |
Keyword 25 | 500 | 7 | 0 | 66 | -1 | Tag 1 |
Keyword 26 | 400 | 2 | -1 | 6 | 0 | Tag 6 |
Keyword 27 | 400 | 4 | 2 | 8 | -1 | Tag 6 |
Keyword 28 | 400 | 7 | -3 | 11 | -2 | Tag 1 |
Keyword 29 | 400 | 5 | 1 | 44 | -3 | Tag 1 |
Keyword 30 | 400 | 9 | 1 | 42 | -2 | Tag 7 |
Keyword 31 | 400 | 2 | 0 | 5 | 0 | Tag 1 |
Keyword 32 | 400 | 10 | 2 | 15 | 6 | Tag 10 |
Keyword 33 | 400 | 10 | 0 | 53 | -3 | Tag 1 |
Keyword 34 | 400 | 10 | -1 | 73 | -2 | Tag 1 |
Keyword 35 | 400 | 8 | -1 | 0 | 0 | Tag 1 |
And Below is how we want it to dispaly - Basically there will be a tab for eacg Tag ( there could be 50 of these) and I want each tags results filtered onto each tab like below
Store 1 | Store 2 | |||||
Keyword | Search Volume | CURRENT | DIFFERENCE | CURRENT | DIFFERENCE | Tags |
Keyword 1 | 1000 | 16 | -4 | 63 | -14 | Tag 1 |
Keyword 5 | 700 | 5 | 0 | 11 | -1 | Tag 1 |
Keyword 8 | 700 | 3 | 1 | 69 | -6 | Tag 1 |
Keyword 11 | 600 | 4 | 0 | 15 | 4 | Tag 1 |
Keyword 14 | 600 | 1 | 0 | 15 | 2 | Tag 1 |
Keyword 17 | 600 | 1 | 0 | 21 | 3 | Tag 1 |
Keyword 18 | 600 | 17 | -1 | 14 | 0 | Tag 1 |
Keyword 20 | 500 | 16 | -1 | 17 | 2 | Tag 1 |
Keyword 21 | 500 | 8 | 0 | 3 | 0 | Tag 1 |
Keyword 22 | 500 | 9 | -3 | 1 | 1 | Tag 1 |
Keyword 25 | 500 | 7 | 0 | 66 | -1 | Tag 1 |
Keyword 28 | 400 | 7 | -3 | 11 | -2 | Tag 1 |
Keyword 29 | 400 | 5 | 1 | 44 | -3 | Tag 1 |
Keyword 31 | 400 | 2 | 0 | 5 | 0 | Tag 1 |
Keyword 33 | 400 | 10 | 0 | 53 | -3 | Tag 1 |
Keyword 34 | 400 | 10 | -1 | 73 | -2 | Tag 1 |
Keyword 35 | 400 | 8 | -1 | 0 | 0 | Tag 1 |
Appreciate any direction in the right path