Add blank row in data set IF no data exists

[davie_aus]

Hey guys,

Sorry, pretty new to this stuff so hopefully i can accurately describe what im trying to achieve.

I need to have 3 rows for each DAY/NIGHT to filter through to more functions. At times, i only have 1 value for this shift so will need to insert 2 new rows to make things balance. I would like to run a Macro to insert blank rows back into the dataset. Does this make sence and is it possible?

Thanks alot!

What i have:

Day/Night Shift	Date Code	Value
Day	1/1/2018	900
Day	1/1/2018	800
Night	1/1/2018	1000
Night	1/1/2018	700
Night	1/1/2018	600
Day	1/2/2018	900
Night	1/2/2018	100
Night	1/2/2018	900
Day	1/3/2018	1000
Night	1/3/2018	690

<tbody>
</tbody>

And this is what im trying to get:

Day/Night Shift	Date Code	Value
Day	1/1/2018	900
Day	1/1/2018	800
Night	1/1/2018	1000
Night	1/1/2018	700
Night	1/1/2018	600
Day	1/2/2018	900
Night	1/2/2018	100
Night	1/2/2018	900
Day	1/3/2018	1000
Night	1/3/2018	690

<tbody>
</tbody>

 

[davie_aus]

What i have:

Day/Night Shift	Date Code	Value
Day	1/1/2018	900
Day	1/1/2018	800
Night	1/1/2018	1000
Night	1/1/2018	700
Night	1/1/2018	600
Day	1/2/2018	900
Night	1/2/2018	100
Night	1/2/2018	900
Day	1/3/2018	1000
Night	1/3/2018	690

<tbody>
</tbody>

And this is what im trying to get:

Day/Night Shift	Date Code	Value
Day	1/1/2018	900
Day	1/1/2018	800
Night	1/1/2018	1000
Night	1/1/2018	700
Night	1/1/2018	600
Day	1/2/2018	900
Night	1/2/2018	100
Night	1/2/2018	900
Day	1/3/2018	1000
Night	1/3/2018	690

<tbody>
</tbody>

 

[My Aswer Is This]

Can we assume the word Day is in column A ?

 

[davie_aus]

Yes, thats correct.

The amount of rows will vary, up to a max of 168 rows if that makes a difference.

If you need anything else, please let me know!

Thanks