Lets say we have 3 columns of data.
A: contains a unique reference
B: contains a start date
C: contains an end date, in some cases the end date is blank.
What I would like to do is explode the data out to show a link for each date.
So for example:
A1 10/1/2017 13/1/2017
A2 12/1/2017 12/1/2017
A3 14/1/2017 16/1/2017
A4 10/1/2017 NULL
So the output would be:
A1 10/1/2017
A1 11/1/2017
A1 12/1/2017
A1 13/1/2017
A2 12/1/2017
A3 14/1/2017
A3 15/1/2017
A3 16/1/2017
A4 10/1/2017
A4 11/1/2017
A4 12/1/2017
A4 13/1/2017
A4 14/1/2017
A4 15/1/2017
Thank you. Lucy
A4 16/1/2017
Bookmarks