Need to show Data in excel format using c#, Asp.net.

Question

I have a data fetched from sql server in datatable using c# and Need to show in excel sheet in specific format.

Below is the data.

 

Hatch	Deck	Orgzn	Num
H1	A	9J	37
H1	A	AY	105
H1	A	KO	12
H1	A	KV	68
H2	A	ZL	62
H2	A	UU	20
H4	A	DO	281
H4	A	SA	95
H1	B	1Z	69
H1	B	7V	49
H3	B	K0	20
H4	B	1Z	69
H4	B	7V	49
H4	B	K0	20
.	.	.	.
.	.	.	.
.	.	.	.
N	N	N	N

 

 

 

Expected Excel sheet format::