One way ..

Assume you have

in Sheet1
--------------
in cols A to C,
data from row1 down

Asad 1007 xyz
Jamil 1039 trb
etc

In Sheet2
-------------
Put in A2:

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

Copy A2 across to C2, fill down by
twice as many rows as there is data in Sheet1.

E.g.: if Sheet1 has 20,000 rows of data,
fill down to C40000

This'll "insert" an alternate "blank" row in-between
the data from Sheet1

In Sheet3
-------------
Put

In A1: =IF(Sheet2!A1="","Employee Name",Sheet2!A1)
In B1: =IF(Sheet2!B1="","Employee ID",Sheet2!B1)
In C1: =IF(Sheet2!C1="","Address",Sheet2!C1)

Select A1:C1, copy down to C40000

The above will return what you're after,
viz. for the sample data, you'll get in A1:C4:

Employee Name Employee ID Address
Asad_________1007________xyz
Employee Name Employee ID Address
Jamil_________1039________trb

Kill the formulas in A1:C40000 with an-in place:
Copy Paste special values OK
(or just copy and paste special as values on another sheet)

Select A1:C40000

To select the range, type in the Name Box*:
A1:C40000,
then press ENTER
*the box with the drop-arrow just to the left of the formula bar

Then right-click on the selected range Copy
Right-click again on the range Paste special Values OK

(this'll kill all the formulas in A1:C40000)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ams0007" wrote in message
...
Kindly tel me how can i be able to put the header row before each row of a
data base contains about 20,000 rows in excel or access i.e.

Employee name employee ID Address
Asad 1007 xyz
Employee name employee ID Address
Jamil 1039 trb
.
.
.