Results 1 to 9 of 9

formula for combining multiple dates, from columns to rows

Threaded View

  1. #1
    Registered User
    Join Date
    12-29-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    4

    formula for combining multiple dates, from columns to rows

    Hi, I need some help, I have being for this for more than 1 week. I would like to combine different date and hours in different columns and rows, and intercalate them into one column. For Example

    (A)=Date
    1= Time1= 6:30
    2= Time2= 7:30
    3= Time3= 8:30

    (A)1 (A)2 (A)3
    (B)1 (B)2 (B)3
    (C)1 (C)2 (C)3
    (D)1 (D)2 (D)3

    or

    ROW COLUMN A COLUMN B COLUMN C
    1 (11/22/2012) 06:30 (11/22/2012) 07:30 (11/22/2012) 08:30
    2 (11/23/2012) 06:30 (11/23/2012) 07:30 (11/23/2012) 08:30
    3 (11/24/2012) 06:30 (11/24/2012) 07:30 (11/24/2012) 08:30
    4 (11/25/2012) 06:30 (11/25/2012) 07:30 (11/25/2012) 08:30


    the result must be something like this:

    (A)1
    (A)2
    (A)3
    (B)1
    (B)2
    (B)3
    (C)1
    (C)2
    (C)3
    (D)1
    (D)2
    (D)3

    or

    Row Column A
    1 11/22/2012 06:30
    2 11/22/2012 07:30
    3 11/22/2012 08:30
    4 11/23/2012 06:30
    5 11/23/2012 07:30
    6 11/23/2012 08:30
    7 11/24/2012 06:30
    8 11/24/2012 07:30
    9 11/24/2012 08:30
    10 11/25/2012 06:30
    11 11/25/2012 07:30
    12 11/25/2012 08:30

    Thank you for your help.
    Attached Files Attached Files
    Last edited by juliomanco; 12-29-2012 at 01:25 PM.

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