Results 1 to 8 of 8

Copy Rows and Expand Dataset

Threaded View

  1. #8
    Registered User
    Join Date
    02-08-2010
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Copy Rows and Expand Dataset

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1