When asking for help with a spreadsheet, it’s best to distill the need down to concepts. It might not be the real work that you need help with, or even the real data. However, by distilling a challenge down to the fundamental concepts and building nonsensical models, we can see our way past technical jargon, complex workflows and data spread across multiple sources.
Otherwise, we’re trying to wrestle an octopus. And for those of you who’ve have that misfortune, you know that wrestling an octopus is miserable.
For an intro to Get & Transform (Power Query) try my Lynda.com course:
My book: Guerrilla Data Analysis 2nd Edition
My old blog: http://datascopic.net/blog-2-2