Copy values from columns with multiple rows into one column

[wayneroad]

Hi everybody!

As the title suggest: I am looking for a forumlar which can copy columns with multiple rows into one column.

I made a little screenshot which clears things up hopefully.
Unbenannt.PNG

These columns go on until column "BOW".

Help is much appreciated.

-wayne

[Pete_UK]

Many contributors cannot view .png files on this forum due to incompatibilities with some browsers - attach a sample workbook instead.

Pete

[wayneroad]

Ok. No problem!

DK.xlsx

[thup_98]

Please see attached file. It may help
Best Regards
Thup_98

[Czeslaw]

If correctly understood, so.
The first line was the date in text format.

[wayneroad]

Hey Czeslaw!

Thanks for your reply. This already looks very promising.
One thing though. It seems like your algorithm is taking the values from the diagonal (in this case E2, F3, G4... and puts it into D2, D3, D4,...).
But what I need is the following:

The values from E2 to E25 should be copied to D2 to D25.
Then the values from F2 to F25 should be copied to D26 to D49.
Then the values from G2 to G25 should be copied to D50 to D73

and so on....

Thanks so far!
-Julian

[Czeslaw]

Then I suggest that option.