Is it possible to summarize this data?

Hi,

I have some raw data that is in the below format;

HTML Code: 

I have roughly 1,000 lines of this data. The columns headers are just times in a 24-hr format and the rows are rating values.

I basically want to see when the ratings were “active” (i.e, not zero) for each type (Type A, TypeB etc). So at the moment I’m manually going through and recording the below;

HTML Code: 

I can see myself making an error doing this manually and it is also a boring repetitive process. Does anyone know of a quicker way to do this? Through a macro or a pivot table? - I'm having problems uploading an example spreadsheet, hence why I've put the data tables in this post.

I’d be grateful for any advice/help. Thanks.

change were needed

Please Login or Register  to view this content.

Try this code.

For the last column it takes the hour for the preceding column and add one hour as the "closing time"

Please Login or Register  to view this content.