sandy666
06-10-2020, 07:43 PM
What is PowerQuery (https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query)
Getting started with PQ (https://support.office.com/en-us/article/getting-started-with-get-transform-in-excel-a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=en-US&ad=US)
PowerQuery Help (https://support.office.com/en-us/article/Microsoft-Power-Query-for-Excel-Help-2b433a85-ddfb-420b-9cda-fe0e60b82a94?CorrelationId=5cc8d039-a622-404f-a9fe-1a04d52f249b&ui=en-US&rs=en-US&ad=US)
PowerQuery M reference (erratum required) (https://docs.microsoft.com/en-gb/powerquery-m/power-query-m-reference)
PowerQuery add-in for XL 2010/2013 (https://www.microsoft.com/en-us/download/details.aspx?id=39379), all above has PQ built-in
General: Excel Help (https://support.office.com/en-gb/excel)
or all-in-one: Power Query documentation (https://docs.microsoft.com/en-us/power-query/)
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 !
_ (s://excelfox.com/forum/forum.php)_ (s://excelfox.com/forum/showthread.php/2555-more-about-PowerQuery-aka-Get-amp-Transform-(links))_ (https://excelfox.com/forum/forum.php)_ (https://excelfox.com/forum/showthread.php/2555-more-about-PowerQuery-aka-Get-amp-Transform-(links))
https://i.postimg.cc/cLMs2N0H/qrcode.png
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
Getting started with PQ (https://support.office.com/en-us/article/getting-started-with-get-transform-in-excel-a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=en-US&ad=US)
PowerQuery Help (https://support.office.com/en-us/article/Microsoft-Power-Query-for-Excel-Help-2b433a85-ddfb-420b-9cda-fe0e60b82a94?CorrelationId=5cc8d039-a622-404f-a9fe-1a04d52f249b&ui=en-US&rs=en-US&ad=US)
PowerQuery M reference (erratum required) (https://docs.microsoft.com/en-gb/powerquery-m/power-query-m-reference)
PowerQuery add-in for XL 2010/2013 (https://www.microsoft.com/en-us/download/details.aspx?id=39379), all above has PQ built-in
General: Excel Help (https://support.office.com/en-gb/excel)
or all-in-one: Power Query documentation (https://docs.microsoft.com/en-us/power-query/)
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 !
_ (s://excelfox.com/forum/forum.php)_ (s://excelfox.com/forum/showthread.php/2555-more-about-PowerQuery-aka-Get-amp-Transform-(links))_ (https://excelfox.com/forum/forum.php)_ (https://excelfox.com/forum/showthread.php/2555-more-about-PowerQuery-aka-Get-amp-Transform-(links))
https://i.postimg.cc/cLMs2N0H/qrcode.png
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