Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Yes, my example was deceptively small :c) It's not too much dates (4 years) but actually quite a lot of on/off items. My goal is to create - as easily as possible - a "item(data)" line graph for each of the items, but I'm not an Excel expert at all. I was thinking/hoping that some DataQuery wizardry could get my data in shape. I'm otherwise tempted to script a little .txt->.txt command line tool instead. But your code snipped was interesting to see for me. I've learnt something new, so thank you!
Thank you! While I'm not sure this is optimal, it certainly did the trick. The macro runs 3min on my spreadsheet getting to 205k single entries that way.
@rkagerer I think it's very unlikely anybody will pick up your question from a comment like this. You possibly should post it as a separate question, potentially linking this one here.
@Theo thanks for this comment. I did get the correctly clipped output in my exported files, it just that I a) don't get the full description text, b) don't seem to get all events (no shutdown/restart)