Transposing a column to several rows?

Here's one way, but it will involve several steps....

F3, copied down:

=IF((A3<>"")*(A2=""),ROW()-ROW($F$3)+1,"")

G3, copied down and across to Column K:

=IF(COUNTA($A3:$D3)=4,OFFSET($A$3,(LOOKUP(9.99999999999999E+307,$F$3:INDEX($F$3:$F3,MATCH(9.99999999999999E+307,$F$3:$F3)))-1)+(COLUMN()-COLUMN($G3)),0),"")

L3, copied down and across to Column N:

=IF($G3<>"",B3,"")

Now, do the following...

1) Select/highlight Columns G through N

2) Edit > Copy > Edit > Paste Special > Values > Ok

3) Select/highlight Columns G through K

4) Edit > Go To > Special > Constants > check 'Numbers' only (uncheck the others) > Ok

5) Edit > Clear > Contents

6) Select/highlight Column F

7) Edit > Clear > Contents

Hope this helps!

Many thx, to both of you!

And Domenic, I got it! :-)






I'm gonna be using this forum some more in the future :-)



ncikusa