GridView Column values saved in Rows field

You can do in 2 ways, either read excel and insert into db or use pivot function (as your requirement). https://www.timeatlas.com/switch-excel-columns-rows/amp/