Hello! This is my first post so bare with me.
I receive data that is a weekly value but I need it to matchup daily.
Example:
Weekly Data:
Column A Column B
5/24/1996 Health
5/31/1996 Energy
6/7/1996 Materials
Need it to matchup as follows:
Column C Column D
5/24/1996 Health
5/28/1996 Health
5/29/1996 Health
5/30/1996 Health
5/31/1996 Energy
6/3/1996 Energy
6/4/1996 Energy
6/5/1996 Energy
6/6/1996 Energy
6/7/1996 Materials
6/8/1996 Materials.....etc. etc.
Thanks for your help
Bookmarks