Timestamped data from multiples sources

[carrmatt02]

So, here's my challenge. I have multiple sources of data that are monitored and recorded. They have either an open or closed value which is presented as "true" or "false." With each true or false value that is reported, an exact time stamp down to the second is associated with it. My problem is trying to get this data in to a single graph or some other easy way of analysis. I have attached the data so it can be better seen. I'm clueless on this one and have struggled with it so any help is appreciated!

Example.xlsx

[oeldere]

@carrmatt02

I would solve it like this.

1) run the macro Sub CONVERTROWSTOCOL()

2) run the macro Sub DeleteBlankRows_in_kolom_C()

After that I made an pivot table of it.

See the attached file.