Hi experts,

I have a problem which I seem to be unable to solve myself and would appreciate your help.

I have a table with widely scattered entries and want to get that into a more compact format. In every column I only have a few values but for the sake of getting a first feeling for the data I would like to have a formula that finds me the first value in the array and puts it in cell1 of my new table, screens to find the second value in the same line and puts it in the next cell of my new table and so on. This would allow me plot data and perform all kinds of analyses.

To put it into a picture:
Attachment 332401

Any idea how to do that?

There is actually a trickier version of what I would need but I am not sure it is still feasible without proper programming. Because actually each column is a date and the values are growth data. If it was possible to extrapolate between values and adjust the table so that each output value of the new table corresponds to exactly 30days between values (at the moment it is sometimes 28, sometimes 32) that would be brilliant. But it would require to correlate each value to the date of the column, do the same for the following value, calculate the number of days between values, get a regression for both dates and calculate the new value for day 30. As this is probably a bit more than is manageable the simple version above would already be a good start.

Thanks a lot for your brains and time.

Cheers,
Tass.