alternate copying of cells

[Andre1210]

Hello everyone

I want to copy the values in columns A and B alternately into column D (see Excel file), so that column D looks like in the file. But this should happen automatically, because I would have to copy a lot of values in this way.
Is there a way to do this with a formula in Excel?

Thank you very much for your help!

[Zer0Cool]

I did in E1, filled down:

Please Login or Register  to view this content.

I am sure there are a dozen different ways to do it. This may not be the best, but its what came to mind first.

[ranman256]

Please Login or Register  to view this content.

[Andre1210]

Thank you, that worked perfectly with the formulas.

Now I have a similar problem, but with three columns. Somehow the old solution doesn't seem to work. Can someone help me with that?

Columns A, B and C are to be used to create column E with formulas.

[Zer0Cool]

As your needs are evolving I figure ill give you a sample that handles any number of columns.

See attached, take note it uses named ranges to help simplify the formula.

I am sure there are other approaches, like modifying the formula I already gave you to account for the extra x columns.