+ Reply to Thread
Results 1 to 3 of 3

Transpose data based on value changing in 1st column

  1. #1
    Registered User
    Join Date
    03-14-2011
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    23

    Transpose data based on value changing in 1st column

    I located the following thread and I'm trying to modify the macro to meet my needs.
    http://www.excelforum.com/excel-new-...ingle-row.html

    I have data that exports from a database with the following format and I need to format the data to the desired transposed data format.
    How do I accomplish this? The data is only a snippet of the data.

    Date Time Value
    4/19/2013 23:13:00 51
    4/20/2013 0:46:00 56
    4/20/2013 7:05:00 126
    4/21/2013 9:09:00 77
    4/21/2013 12:09:00 75
    4/22/2013 14:12:00 105

    Desired result after transpose
    Date Time1 Value1 Time2 Value2 Time3 Value3
    4/19/2013 23:13:00 51
    4/20/2013 0:46:00 56 7:05:00 126
    4/21/2013 9:09:00 77 12:09:00 75
    4/22/2013 14:12:00 105

    How do I modify the macro found in the above mentioned thread and shown below to accomplish what I need to do?
    Thanks

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Transpose data based on value changing in 1st column

    Hi

    Assuming that your data is in the range A1:C7, and you have an existing blank sheet called sheet2, then try
    Please Login or Register  to view this content.
    rylo

  3. #3
    Registered User
    Join Date
    03-14-2011
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    23

    Re: Transpose data based on value changing in 1st column

    rylo,
    Thanks so much for your reply.
    Your code does just what I need.
    I have up to ten readings per date and this code handles the task.

+ 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