This should really be posted to excel.finctionsb ut to answer your question;
Why not a simple formula like "=D1&D1&C1&C1&B1&B1" then copy it down?

"Mika" wrote:

Hi,

I have a table in columns A trough E and the data in columns C and D,
I need to repeat and copy in a sigle column(column p for instance) in
this order:

d1
d1
c1
c1
d2
d2
c2
c2
..
..
..
I was trying with an expresion like: =INDEX($D:$D,(ROW())) for and easy
copy but can not figure out a proper formula... any help ?