ExcelBanter - transpose formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - transpose formula (https://www.excelbanter.com/excel-programming/351630-transpose-formula.html)

Mika

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 ?

Candyman

transpose formula

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 ?

All times are GMT +1. The time now is 12:07 PM.