[mmob]

Have you tried using Power Query (Get & Transform) in Excel? I'd be surprised if it couldn't address your requirements for analyzing your data.