transpose formula

  • Thread starter Thread starter Mika
  • Start date Start date
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... any help ?
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose copy 2
Macro to concatenate columns 1
VBA to create new data help please 2
Auto update/fill column heading 4
Insert columns and values programmatically with IF statement 9
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Transpose problem 2
Macro that analyses 3 columns and put results in 4th 5

Back
Top