Creating 16 blank rows every 50 rows

Question

How do I create 16 blank rows every 50 rows? I have data in a time frame of 0:00-23:30 and my data only starts at 8:00 but from 0:00-7:30 I need blank rows. I will attach what my correct output should look like and what my input is.  This is in Alteryx btw.

I am on a deadline so I would appreciate all the help and ideas!

Thank you,

Riya

correct out.png

sha sc.png

alexnajm · Answer

I tried to keep it to just the question asked, since I wasn’t sure how much you built so far. Good luck!

riyarojan · Answer

Sadly this is not what I'm looking for but it did give me an understanding so thank you so much for helping me and making this workflow!!

Greatly appreciated

Riya

alexnajm · Answer

@riyarojan, this is the best I could do with my limited knowledge of your current process! It will take too long to get it to your desired output, but hopefully this will get you on your way...

Creating 16 blank rows every 50 rows.yxzp