I have data like this: Group Start Date End Date A 01JAN2014 02JAN2014 B 02JAN2014 04JAN2014 From the table above I'd like to create an output table for each group that would look like the following: output table A Group Date A 01JAN2014 A 02JAN2014 output table B Group Date B 02JAN2014 B 03JAN2014 B 04JAN2014 As you can see, it's simply stacking data and then creating/populating rows between a start date and end date. I'm looking to do this type of manipulation in either enterprise guide or jmp so suggestions for either approach are welcomed.
... View more