"Biff" wrote:
....
I don't know!
If that's what they want, then
why are they essentially transposing row 1 every othe cell?

I don't know why the OP wants it this way either <g,
but that's the way I interp'ed that part of the post/request literally ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----