Transpose copy

M

Mika

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 (I need formulas in the
cells not values)... any help ?
 
H

Herbert Seidenberg

Enter this formula and copy down:
="^="&CHAR(67+IF(MOD(ROW()-1,4)<2,1,0))&FLOOR((ROW()-1)/4,1)+1
Paste Special > Value
Then Find/Replace the caret character
 
Top