Match up specific IDs with a count by group

[Grisham312]

I'm really unsure how to search for my question in the community because it is very specific.  However, I'm trying to match up times with counts and apply those counts to times with specific IDs in the order that the IDs are listed. 

For example, if I have a count of 3 at 7:00, in the order of the ID's I want each ID to get an X and if there are any left over then blank.

I've attached an excel with the two inputs and the output I'm trying to get.

Thank you.

[atcodedog05]

Hi @Grisham312 

The attached excel seems to be missing can you please reattach🙂

[Grisham312]

Thank you for bringing this to my attention. I just tried to upload it again. 

[atcodedog05]

Hi @Grisham312 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

If this post helps you please mark it as solution 😀

Feel free to reach out if you face any other issues 🙂