Creating 16 blank rows every 50 rows

[riyarojan]

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

[alexnajm]

I am a bit confused on the output - it looks like you would want data from 11:00 to 19:00 because that's the gap in the original data right? 

Also it will be hard for us to help without the data in hand - can you please attach a sample?

[riyarojan]

The "sha sc" data is in a different time zone which is why it starts at 19:00, I need to create in Alteryx a time column that includes midnight to midnight 0:00-23:30. The 19:00 is actually 8:00 in the time zone that I need which is why 0:00-7:30 should be 0s or blank in the correct output. This format in the sha sc is in an excel file that gives me data for 7 days that's all in that same format which is why I need to repeat the blank rows every 50 or so rows. 

The data I'm using is confidential but I can see if I can attach sample data that will match the format. 

Thank you

Riya

[riyarojan]

I attached sample files. The correct output is just one day but keep in mind I would have tabs in the excel file for each day with the same format. 

Thank you for helping!

[alexnajm]

@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...

[riyarojan]

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]

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