+ Reply to Thread
Results 1 to 2 of 2

Sorting/Rearranging Large data set

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    michigan
    MS-Off Ver
    Excel 2010
    Posts
    2

    Sorting/Rearranging Large data set

    I need to rearrange/sort this massive data for my research

    Basically this data is about 500000 x 300 right now.
    500000 rows represent different points in a region of a park (rectangle, 250m apart), and they are specified by first two columns (X and Y point).
    Then, the column goes from 2000 jan 1 to present day. The dates are 16 days apart, and each day the value of ndvi (how gree the field it) was measured for each 500000 point. Then the column goes again with how reliable the ndvi is (calling it the p-value), again from 2000 jan 1 to present.


    So, what I'm trying to do is I want to rearrange the data so that, all the dates will be in 1 column, and ndvi/pvalue will be right next to it

    RIGHT NOW

    x y N20000101 N20000117 .... N20120505 P20000101 P20000117 ..... P20120505
    1 1 .100 .200 .... .200 1 2 ..... 1
    1 2 .110 .201 .... .233 0 2 ..... 1
    .....


    I WANT TO

    x y Date NDVI P
    1 1 20000101 .100 1
    20000117 .200 2
    .....
    20120505 .200 1
    1 2 20000101 .110 0
    20000117 .201 2
    .......


    You get the idea. Please let me know if you have any idea of how to approach this. Thank you!

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Sorting/Rearranging Large data set

    Provide a small sample workbook with a sufficient set of data to represent the need, no more than 10-20 rows or so I'd gather. The sample workbook should have a BEFORE and an AFTER sheet in it. That should make it simple to assist you and test out our ideas.

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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