How to build a dashboard based on interactions data

[#1]

I have a tabular interactions data with column headers and data below them, along with it I have another workseet which has hours in a day (starting from 0 - 23), cannot use the cross tab since can expect the data structure to change. I want to populate the count of data under each hour.So please suggest how can i do this. Below is the expected output that I am looking for.