Thanks, Alok !

Yes, building further from your suggestion,
think it could be done in one step in Sheet2
via putting in A1 (in Sheet2):

=IF(MOD(ROW(A1),2)=1,CHOOSE(COLUMN(A1),"Employee Name","Employee
ID","Address"),OFFSET(Sheet1!$A$1,(ROW(A1)+1)/2-1,COLUMN(A1)-1))

then copying A1 across to C1, and filling down to C40000

(Above assumes data in Sheet1 is in cols A to C, from row1 down)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Alok Joshi" wrote in message
...
Hi Max,
Developing your idea further, one can probably do this in one step using
the
formula in B1 copied to cells below if the Name heading is in A1 and
actual
names are in A2 and below.
=IF(MOD(ROW(),2)=1,$A$1,OFFSET($A$1,ROW()/2,0))
Alok