View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mika Mika is offline
external usenet poster
 
Posts: 48
Default transpose formula

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 ?