I am getting a table from a DB and need to show this data table in excel in a different format.
It is for attendance for different buildings in weekly period based on two different types of accounts. the problem is the building and date columns have repeated entries so I am not sure how to merge them and how to make the datatable fit into the template.
This is the original datatable from the DB
I need to make the datatable fit into this template, where for each building get the attendance for the different account types on different days of the week