empty rows for running total

[terrellchong]

I have a set of data that i would like to make some rows for the empty quarter. I had attached an example input and output for reference.

[Luke_C · Accepted solution]

Hi @terrellchong 

Did you try the generate rows tool? 

I created a record for each value between the min/max of the 2nd column in your data. Then appended the ones that didn't already have data and set them to 0

[MatthewBr]

Maybe not the most efficient but you can do something like this...

[MatthewBr]

Definitely need to leverage the GENERATE ROWS tool