Nice, pivot tables rock. I tend to use Power Query to unpivot tables. But for a really quick fix, your option is good and is something I never considered.

Welcome to steem by the way and to Excel for All. This is a new community and is in beta so subject to change. however, there are exciting things to come so do keep an eye on the community announcements.