Hello Guys. I'm in the process of display the employee attendence on a datagrid and later export it to excel. I can do it without any problems. But now i would like to transpose the dates field on the database to make it appear like a column rather than a row. Any suggestions on how to accomplish this would be highly appreciated. Thanks in advance
Attached are the database structure and desired layout.