Transpose Column to Row but with condition

[rr1050]

Hello there,

I am looking for transpose C2:C20, into rows starting from D1 but every alternate merged rows.
Means C2 data copy in D1:E1 Mearged rows
C3 into F1:G1 Mearged rows

Here the condition is D1 & E1 are merged cell....
So on F1&G1 mearge, and further.

THANKS, RR

[kvsrinivasamurthy]

IN D1 then copied across.

=IFERROR(INDEX($C$2:$C$21,1+INT(COLUMNS($D$1:D$1)/2)),"")

[rr1050]

Many Thanks, in the formula it worked.

I am looking for VBA solution if any one.

[mjr veverka]

And what about a sample xls file ?

[rr1050]

Sample Xls file, I thought that may have VBA solution. But it was explained with formula only.

[mjr veverka]

... a sample xls file from You ...

[kvsrinivasamurthy]

CODE for macro

Please Login or Register  to view this content.

[rr1050]

Perfectly work
I modified little...

Please Login or Register  to view this content.