+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Transpose records based on date

  1. 10-20-2011, 07:42 PM #1
    aldek
    aldek is offline
    Registered User
    Join Date
    06-06-2011
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    23

    Transpose records based on date

    Hi all!
    I would like to transpose some records from this format where the number after the date is the identifier:

    column 1 column 2

    Sunday, January 23, 2011 0
    Saturday, September 11, 2010 0
    Saturday, January 09, 2010 0
    Monday, August 31, 2009 0
    Monday, October 17, 2011 1
    Thursday, April 21, 2011 1
    Wednesday, November 10, 2010 1
    Friday, August 27, 2010 1
    Friday, April 30, 2010 1
    Thursday, February 04, 2010 1
    Tuesday, November 03, 2009 1
    Monday, September 28, 2009 1
    Monday, July 06, 2009 1


    To this format:

    column 1 Column 2 Column 3 Column 4

    0 Sunday, January 23, 2011
    1 Monday, October 17, 2011 Thursday, April 21, 2011


    This just transposes records which occur in 2011. Any suggestions?
    Thanks so much!
    Attached Files Attached Files
    Last edited by aldek; 11-03-2011 at 12:36 PM. Reason: I added a sample workbook.
    Reply With QuoteRegister To Reply
  2. 10-20-2011, 11:45 PM #2
    Azam Ali
    Azam Ali is offline
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Transpose records based on date

    it seem possible

    upload a sample workbook with sample data and your desired results

    In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.
    Reply With QuoteRegister To Reply
  3. 10-21-2011, 02:08 PM #3
    aldek
    aldek is offline
    Registered User
    Join Date
    06-06-2011
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Transpose records based on date

    Hi Azam,
    I added the workbook as you suggested.
    I am trying to get from the information in Columns A and B to the columns to the right. Thanks!
    Reply With QuoteRegister To Reply
  4. 10-25-2011, 02:56 PM #4
    aldek
    aldek is offline
    Registered User
    Join Date
    06-06-2011
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Transpose records based on date

    Hi, still looking for help on this. Thanks.
    Reply With QuoteRegister To Reply
  5. 10-27-2011, 02:51 AM #5
    Azam Ali
    Azam Ali is offline
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Transpose records based on date

    Hi aldek
    see attatchment

    i was away for few days which cause this dealy
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 11-03-2011, 12:35 PM #6
    aldek
    aldek is offline
    Registered User
    Join Date
    06-06-2011
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Transpose records based on date

    Azam,
    That works great! Thanks so much for your time and attention!
    Aldek
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1