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

Well, you will have to write custom logic to generate such excel sheet. Pick col span 2 as header and then filter records based on Deck = 'A' , Deck = 'B' and so on. Write to each cell value based on header (H1/ H2/ H3...) and Deck (A/ B/C ..). https://blog.e-zest.com/how-to-generate-the-dynamic-spreadsheet-in-dotnet