+ Reply to Thread
Results 1 to 6 of 6

how to match data by dates in the same sheet and split into columns

  1. #1
    Forum Contributor
    Join Date
    04-09-2012
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2007
    Posts
    117

    how to match data by dates in the same sheet and split into columns

    Dear All,
    Greetings! Its wonderful to be connected to this forum. I'm struggling with this question and have looked at various threads before posting here. I will demonstrate with an example to make it clearer for you kind folks:
    Current data:
    Date: Unique code Value
    date 1 x 0.2
    date 2 x 0.1
    date 3 x 0.67
    ....... x 0.23
    ....... x 0.34
    ...... x 0.19
    date N x 0.29
    date 1 y 1.03
    date 2 y -0.32
    date 3 y 0
    ....... y 2.3
    ....... y -
    ...... y -
    date N y 2.007
    date 1 z 0.98
    date 2 z 1
    date 3 z 2
    ....... z -0.99
    ....... z 1.1
    ...... z 4
    date N z 0.89

    What I want is:

    Date: Unique code x's value Unique code y's value Unique code z's value
    date 1 0.2 1.03 0.98
    date 2 0.1 -0.32 so
    date 3 0.67 so on on
    ........ so
    ........ on
    ........
    date N 0.29 2.007 0.89


    As you guys can see the dates are same for each code. Please let me know if there is a way/formula to do this. Thanks a lot in advance!

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,410

    Re: how to match data by dates in the same sheet and split into columns

    It is possible, if you post an example file.
    Quang PT

  3. #3
    Forum Contributor
    Join Date
    04-09-2012
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2007
    Posts
    117

    Re: how to match data by dates in the same sheet and split into columns

    Sorry I didnt realize that the format has changed. Anyways, I have attached the excel file and my present data format and desired format are in different sheets. As you can imagine, its just a tiny example to simulate the data format; the actual dates are in thousands, but they repeat the same way.
    Thanks again!
    Attached Files Attached Files

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

    Re: how to match data by dates in the same sheet and split into columns

    Hi

    Have you looked at the pivot table option?

    rylo

  5. #5
    Forum Contributor
    Join Date
    04-09-2012
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2007
    Posts
    117

    Re: how to match data by dates in the same sheet and split into columns

    Thanks Rylo. I'm sorry I dont know much about that option. Can you please elaborate if possible? Thanks.

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

    Re: how to match data by dates in the same sheet and split into columns

    Hi

    Select your data, then Insert, Pivot Table, Pivot Table and look at the options available. It will allow you to basically build your matrix with the data in the intersection.

    Try it, and work through the help. It won't give you the same headings (they will be taken from the data), but it will at least build the matrix.

    rylo

+ 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