Hello all - I have a question, I have a dataset that contains a unique ID, a Start Date, and an End Date. What I need to do is create another dataset with the unique member ID populated for a corresponding number of rows for the time between the start and end date. An example is below - anyone have any thoughts?? Original Data: ID Start End 40000000337C00 4/1/2014 5/31/2015 40000000522C00 5/1/2014 5/31/2015 40000000665C00 12/1/2014 5/31/2015 Desired Output: ID Month 40000000337C00 Apr-14 40000000337C00 May-14 40000000337C00 Jun-14 40000000337C00 Jul-14 40000000337C00 Aug-14 40000000337C00 Sep-14 40000000337C00 Oct-14 40000000337C00 Nov-14 40000000337C00 Dec-14 40000000337C00 Jan-15 40000000337C00 Feb-15 40000000337C00 Mar-15 40000000337C00 Apr-15 40000000337C00 May-15 40000000522C00 May-14 40000000522C00 Jun-14 40000000522C00 Jul-14 40000000522C00 Aug-14 40000000522C00 Sep-14 40000000522C00 Oct-14 40000000522C00 Nov-14 40000000522C00 Dec-14 40000000522C00 Jan-15 40000000522C00 Feb-15 40000000522C00 Mar-15 40000000522C00 Apr-15 40000000522C00 May-15 40000000522C00 May-14 40000000665C00 Dec-14 40000000665C00 Jan-15 40000000665C00 Feb-15 40000000665C00 Mar-15 40000000665C00 Apr-15 40000000665C00 May-15 40000000665C00 May-14
... View more