complex data reorganization and processing

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.

Hi,

that is strange, for me it works.

No matter, here it goes again.
result.JPG

Cheers,
Tass.

Hi Siva,

thank you but it is not that simple. Only with shifting cells you cannot solve the problem, one really has to reorganize data in a new table.

Regards.

Dont put image Tasss, better if you have your sample file and attach it here, click "Go Advanced" button and find Paperclip Button to attach your file, maybe with see your file the member could have the solution for you


Cheers

Ok, here is an extract of the table to give you something to work with.

extract forum.xlsx

Thanks a lot for trying.

Cheers,
Tass.

Hey,

still nobody with an idea?

Cheers,
Tass.

A growing table of more than 10'000 entries you don't do manually. Otherwise I would not ask for help.

ah, but can't you see the picture I posted in my first post. Or does it not become clear from that?

Here the pic again: result.JPG

Best,
T.

Hey, that is great!! Wow so quick!

Thanks a lot, that is so useful for me. You made my day! Totally excited.

Have a splendid day!
Best,
Tass.