Hi all,
I have some summarised data that I need to take back to a more granular level in order to visualise it.
What I have looks like this...
Group | Campaign | Outcome | Count |
A | First | Good | 1 |
A | First | Bad | 2 |
A | First | Other | 3 |
A | Second | Good | 2 |
A | Second | Other | 1 |
B | First | Bad | 4 |
B | Second | Good | 2 |
B | Second | Other | 3 |
What I’d like to get to is this...
Group | Campaign | Outcome |
A | First | Good |
A | First | Bad |
A | First | Bad |
A | First | Other |
A | First | Other |
A | First | Other |
A | Second | Good |
A | Second | Good |
A | Second | Other |
B | First | Bad |
B | First | Bad |
B | First | Bad |
B | First | Bad |
B | Second | Good |
B | Second | Good |
B | Second | Other |
B | Second | Other |
B | Second | Other |
Any advice would be greatly appreciated.
Best,
DHB