Un-summarising Data

[DHB]

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

[PhilipMannering · Accepted solution]

Hey @DHB 

You can use the generate rows tool. See attached.

[DHB]

That's perfect, thanks Philip.  I'd been playing around with that tool but hadn't been able to configure it correctly.