Generate Rows

[rickydata]

I'm looking to generate rows between data.

Currently what i have is

Person	Month	Data
Person 1	1	X
Person 1	6	X
Person 1	7	X
Person 1	8	X
Person 1	9	X
Person 1	10	X
Person 1	11	X
Person 1	12	X
Person 2	1	X
Person 2	6	X
Person 2	7	X
Person 2	8	X
Person 2	9	X
Person 2	10	X
Person 2	11	X

But I want to make it look like

Person	Month	Data
Person 1	1	X
Person 1	2	null
Person 1	3	null
Person 1	4	null
Person 1	5	null
Person 1	6	X
Person 1	7	X
Person 1	8	X
Person 1	9	X
Person 1	10	X
Person 1	11	X
Person 1	12	X
Person 2	1	X
Person 2	2	null
Person 2	3	null
Person 2	4	null
Person 2	5	null
Person 2	6	X
Person 2	7	X
Person 2	8	X
Person 2	9	X
Person 2	10	X
Person 2	11	X
Person 2	12	null

[SPetrie]

Im sure there is a more efficient way to do this, but this is what I cam up with first.

[prpatel · Accepted solution]

Hi Ricky Data,

This is what you need....see attached workflow.

If it works, please accept as answer 😊

-prpatel

[ChrisTX]

Try the attached workflow

Chris

[WesCannon]

Hi @rickydata ,

You can utilize the generate rows and a batch macro to achieve your desired outcome.

[binuacs]

@rickydata One way of doing this

[rickydata]

This one is good for when you have a single field, but within the scope of my data are several fields.  Thanks 

[rickydata]

This one is great! thanks. Simple and can expand with data with multiple fields.