Hi all,
I have a source table containing a start date column and a duration column (as well as other data columns):
<tbody>
</tbody>
Now I would like to change the data to:
<tbody>
</tbody>
I am trying (i.e. I would like to) perform this in the Get and Transform editor.
Is this possible?
I am using:
Win10 Pro x64
Excel 2016 (MS Office 365 ProPlus)
Apologies in case this has been asked before and I was unable to find it.
Many thanks for any hints.
Kind regards,
MLE
I have a source table containing a start date column and a duration column (as well as other data columns):
ID | start date | duration | other data1 |
1 | 1/Jan/16 | 2 | abc |
2 | 15/Feb/16 | 4 | xyz |
... | ... | ... | ... |
<tbody>
</tbody>
Now I would like to change the data to:
ID | date | other data1 |
1 | 1/Jan/16 | abc |
1 | 2/Jan/16 | abc |
2 | 15/Feb/16 | xyz |
2 | 16/Feb/16 | xyz |
2 | 17/Feb/16 | xyz |
2 | 18/Feb/16 | xyz |
... | ... | ... |
<tbody>
</tbody>
I am trying (i.e. I would like to) perform this in the Get and Transform editor.
Is this possible?
I am using:
Win10 Pro x64
Excel 2016 (MS Office 365 ProPlus)
Apologies in case this has been asked before and I was unable to find it.
Many thanks for any hints.
Kind regards,
MLE