+ Reply to Thread
Results 1 to 2 of 2

Reshaping Data

  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

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Reshaping Data

    GQuinn,

    I assume that your data in Sheet1 actually begins in cell A1 with title Payment.

    I can adjust the macro if Sheet1 cell A2 contains the title Payment.

    The macro will create a worksheet Results.

    Detach/open workbook Gquinn - EF746330 - SDG10.xls and run macro ReorgData.
    Attached Files Attached Files
    Last edited by stanleydgromjr; 09-21-2010 at 11:43 PM.
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1