Manipulate datatable into excel template

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

Hello @Mo_Bait_Ishaq

Can you show how output from this template will be, if using this DB

Sure, it will looks something like this


How about the following? (22.3 KB)

The above assumes a pair of Building and AccountType is unique in the table.


1 Like