If the data is in SQL I suggest you write a SQL statement to create the data in the required layout.
Actually seems surprising the data would be in the layout with dates as field names as that goes against standard database design principles. It wouldn't surprise me if your expected table is how the data actually sits in the database.
did you try writing a custom sql using "Unpivot" in sql server query ?
SELECT * FROM TABLE AS T
( VALUE FOR DATE_VAL IN (
9/26/2016 9/27/2016 9/28/2016 9/29/2016 9/30/2016 10/1/2016
The design of the current table in the sql server database that you have shared , has Dates in the column. Is is a Temporary Table and are you adding a new column like 26th Sept , 27th Sep , 28th Sep ... every time you get data ? I am just trying to understand the relevance of this table .
Material 9/26/2016 9/27/2016 9/28/2016 9/29/2016 9/30/2016 10/1/2016 A 1 2 4 5 76 6 B 3 32 65 5 67 3 C 3 6 6 5 6 6 D 45 6 7 5 6 6 E 4 5 6 5 6 6
Ideally per my understanding this is not the way the database table should be designed ,but if this is the table that you suppose to work , you can write custom sql to convert columns into rows in order to pivot your data.