Hi all, I have a set of data where I need to create a row for every month through December 2016 based on a start date. For example, below is how the data looks now:
Rep name Start Date
Alice 10/1/2016
Dave 8/1/2016
And below are the rows I need to end up with (the date format changes as well, but my main concern is generating the rows in an automated way rather than copying/pasting):
Rep name Start Date
Alice October, 2016
Alice November, 2016
Alice December, 2016
Dave August, 2016
Dave September, 2016
Dave October, 2016
Dave November, 2016
Dave December, 2016
Thanks so much for any help you can offer!
Bookmarks