# How to crosstabulate numeric time series data? [closed]

I have some time series data, with the date in column A, and other variables in columns B, C, D...etc. So each row has data specific to that date. All the data, apart from the dates, are numeric.

I want to create a two (or more) column list where each row has the range of values from B in the first column and the average of the corresponding values in C in the second column. So for example a cell in the first column would be for values of B that are equal to or more than 7 and less than 8, and the adjacent cell in the second column would be the average of all the cells in column C where the value in B in the same row is equal to or more than 7 and less than 8. As well as the average I would also like to have columns for the standard deviation, max, min, etc.

What is the easiest or quickest way of doing that please?

So far I have made a column for each range of values in column B, and then the values from C are shown in the column only if B is within a particular range. The columns are then averaged, etc. But this creates a very large table and is tedious to set up.

I have been reading about Pivot Tables, but have seen nothing about sorting numeric values.

"... where each row has the range of values from B in the first column and the average of the corresponding values in C ..."

How should a "range of values" -

how defined?- be represented in one row of one coulmn which is a single cell?If you actually mean that the first column should contain the range of lead values one by one, you also have to specify this range to more detail. Otherwise you would need next to infinitely many rows.

If you mean the

actually occurring valuesof the range:1) There currently are no standard functions allowing to create the contents of this firtst column by simple formulas.

2) Available means would either require helper columns and rather inefficient and complicated formulas - or a certain amount of user programming. This the more if you need the result in a specific order.

If you can provide a list of allowed values in advance the task is simple.