I would just calculate the average (or median?) of the column and plug that
into the gaps. Or do you want some kind of automatic thing?

" wrote:



I am trying to take a set of columns of numbers and adjust them so
they are all the same length.

I.e., i have data that looks like

1 0.2454
2 0.2423 0.2544
3 0.3124 0.4234 0.5436
4 0.5343 0.2423 0.5432
5 0.2532 0.4531 0.6542
6 0.2342 0.5432 0.6344
7 0.5434 0.5234
8 0.4532

i'd like to do a linear adjustment on the data BY COLUMN, such that
everyone is the same number of data points. Smoothing isn't really
what i want (i think), since that would distort the absolute values of
the data.

any ideas?

thanks,
simon