more about PowerQuery aka Get&Transform (links)

[sandy666]

• What is PowerQuery
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference (erratum required)
• PowerQuery add-in for XL 2010/2013, all above has PQ built-in
• General: Excel Help

or all-in-one: Power Query documentation

Power Query is NOT a worksheet formula or any VBA language, so you need to change your mindset and forget what you've learned about a formula or VBA

Power Query IS case sensitive !

____

Remember that there will always be someone better than you with a better solution, but if you created the solution yourself and it works, then you can be proud of it

If you pretend you know something and then it turns out you don't know much, you're dumber than the law says