I am really sorry but I have to change the instructions once again. If you have already done some work to do this, then please let me know if it is too difficult to alter at this point. I am really so sorry if this causes any inconvenience.
It should ALWAYS try and copy ONLY at most 2. There will never be an instance when it needs to copy more than 2, and it should always attempt. For instance,
Id date
1 feb 09
2 mar 09
output:
1 dec 08
1 jan 09
1 feb 09
2 jan 09
2 feb 09
2 mar 09
If it is too difficult, then we could definitely shortcut a fix, by labeling original rows with an indicator. Then we could see if how many new rows lie above each original row. Just a thought
Please tell me if my sample data set is too large.
Bookmarks