+ Reply to Thread
Results 1 to 3 of 3

Merging two time series in columns into one column

  1. #1
    Registered User
    Join Date
    01-23-2012
    Location
    Los Angeles, CA, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Merging two time series in columns into one column

    Hi,

    I'm trying to merge two time series into one single time series.

    For example, time series 1 starts in cell A2 (column A) and extends through cell A11 and time series two starts in cell B2 (column B) and extends through cell B11. I'm trying to merge these two time series into one time series such that the original cell A2 remains at A2 and the original cell B2 moves to cell A3, cell A3 moves to cell A4, cell B3 moves to cell A5. Is there a formula I can use to quickly do this? The entire time series spans over 3000+ data points. I've attached an example of what I'm trying to do.

    Thank you very much for your help!
    Attached Files Attached Files
    Last edited by bpctrader; 02-05-2012 at 05:50 PM.

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Merging two time series in columns into one column

    In C2 put the formula:

    =OFFSET($A$2,INT(ROW()/2)-1,MOD(ROW(),2))

    And copy down. Column C will now contain your merged series.

  3. #3
    Registered User
    Join Date
    01-23-2012
    Location
    Los Angeles, CA, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Merging two time series in columns into one column

    Andrew,

    THANK YOU VERY MUCH! (caps intended)


+ Reply to Thread

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