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::