I have Column A with a date and Column B with a Number.
The dates may skip a day or two or more.
What I need is to expand that data into a date range, i.e. May 21, 2013 to December 31, 2013, and keep the associated demand with the original date, and fill in zero for the rest.
How do I do this? I have researched a few ideas, but no luck. I appreciate the help.
Thank you!
Bookmarks