I think you could probably do it with PowerQuery (Get & Transform on the Data ribbon).