Transpose copy

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mika - 27 Jan 2006 17:02 GMT

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 ?

Reply to this Message

Herbert Seidenberg - 27 Jan 2006 18:37 GMT

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

Reply to this Message

Mika - 27 Jan 2006 19:14 GMT

Prima !!!

it worked like a charm !

Mika

Reply to this Message