ParentFull threadDCoder·Excel has Get & Transform, formerly known as Power Query, which can do similar things... if a custom query language [1] instead of SQL doesn't scare you away. I have used it a few times, it can definitely be useful.[1]: https://msdn.microsoft.com/en-us/library/mt270258.aspxView on HN