Hello, I am trying to summarize and average data in a large table with up to 2.5 million rows and 120 columns. The structure is like this: a single CASE is divided into thousands of REGIONS, each of which can have a RANK (usually ranging from -30 to 30 including zero) and more than a hundred measured different FEATURES in that region: I need to convert this data into two tables. One of them lists down unique CASES with all possible RANK values as colmns and has the count of REGIONS with such a rank in a cell, like this: The second table should be a summary list: mean and standard deviation of each FEATURE per RANK present in a CASE, like this: Of course the two tables can be combined by simply adding a column RANK_COUNT in the second table. I would appreciate your help, Thank you, Rokas
... View more