Import Excel Format on Asp.Net C#

Question

Hi everyone, 

 

How Can i import excel document to datatable like below format

 

excel table format  

 

i`m using to "#" character seperate every part.   

#CODE-1
        A       B       C       D       E
Column1 Value   Value   Value   Value   Value
column2 Value   Value   Value   Value   Value
Column3 Value   Value   Value   Value   Value
column4 Value   Value   Value   Value   Value
Column5 Value   Value   Value   Value   Value

#CODE-2
        Q       W       E       R       T
Column1 Value   Value   Value   Value   Value
column2 Value   Value   Value   Value   Value
Column3 Value   Value   Value   Value   Value
column4 Value   Value   Value   Value   Value
Column5 Value   Value   Value   Value   Value
Column6 Value   Value   Value   Value   Value

#CODE-3
        A       S       F       H       V
Column1 Value   Value   Value   Value   Value
column2 Value   Value   Value   Value   Value
Column3 Value   Value   Value   Value   Value

 

 after import to datatble datatable like below

 

CODE    CAT TYPE    VAL
CODE-1  A   Column1 Valuue
CODE-1  A   Column2 Valuue
CODE-1  A   Column3 Valuue
CODE-1  A   Column4 Valuue
CODE-1  A   Column5 Valuue
CODE-1  B   Column1 Valuue
CODE-1  B   Column2 Valuue
CODE-1  B   Column3 Valuue
CODE-1  B   Column4 Valuue
CODE-1  B   Column5 Valuue
CODE-1  C   Column1 Valuue
CODE-1  C   Column2 Valuue
CODE-1  C   Column3 Valuue
CODE-1  C   Column4 Valuue
CODE-1  C   Column5 Valuue
CODE-1  D   Column1 Valuue
CODE-1  D   Column2 Valuue
CODE-1  D   Column3 Valuue
CODE-1  D   Column4 Valuue
CODE-1  D   Column5 Valuue
CODE-1  E   Column1 Valuue
CODE-1  E   Column2 Valuue
CODE-1  E   Column3 Valuue
CODE-1  E   Column4 Valuue
CODE-1  E   Column5 Valuue

Anybody Have an any idea