I need to automate a schedule with a fixed format to retrieve information from a planner. I have a past due column and a week summary that I need to fill a past due column and break the week summary into daily buckets according to a given rate. I have figured out how to break up the quantity into the daily buckets if I know the total quantity but I can't figure out how to get the item or quantity from the plan to the schedule without having blank values or repeats. Attached is a sample plan with the way I want the schedule to look off to the right.