On Thursday, a software engineer came to me to discuss issues with SQL and data analysis. My suggestion, “I think PIVOT and UNPIVOT might do the job for what you are looking for.” He went back to his desk and tried it. Minutes later, he came back excited letting me know how great it was and he never knew about it. And again, minutes later he he came back and was ecstatic on the progress he was making and wanted to complete the project, but going on vacation. I joked with him, “Bring your laptop to ski resort.” :=)
Sharing your success and excitement motivates me to help you.