Results 1 to 2 of 2

Reshaping Data

Threaded View

  1. #1
    Registered User
    Join Date
    09-16-2010
    Location
    Clearwater, Florida
    MS-Off Ver
    Excel 2007
    Posts
    6

    Reshaping Data

    Hi all,

    I need to reshape data.

    Currently it is in this form:

    Payment Dt1 Dt2 Dt3 Dt4
    15.00 6/7/2009 10/7/2009 2/7/2010
    3.00 8/15/2009 10/15/2009 12/15/2009 2/15/2010


    Payment, Dt1, Dt2, Dt3 and Dt4 are all seperate variables/head up seperate columns.

    I need it to be in the following form:


    Payment Date
    15.00 6/7/2009
    15.00 10/7/2009
    15.00 2/7/2010
    3.00 8/15/2009
    3.00 10/15/2009
    3.00 12/15/2009
    3.00 2/15/2010


    is there any way to do this? Let me know if anything needs to be clarified.

    I attached a spreadsheet with this template for easier viewing.

    thanks much!
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1