Power Query skills How to always find the header row when its position can move, plus other tips
Рет қаралды 10,108
5 жыл бұрынImagine the millions of unproductive hours that would be saved around the world if more people knew what hashtag#Excel is now capable of.
If you're data weary learn hashtagPowerQuery.
@wayneedmondson1065 2 жыл бұрын
Hi Wyn. Great tip! Another more direct method is to use List.PositionOf, as in: = Table.Skip(Source,List.PositionOf(Source[Column2],"Company")). Same result.. just saves a few steps. Thanks for sharing :)) Thumbs up!!
@AccessAnalytic 2 жыл бұрын
Nice tip Wayne
@sanjay381996 4 жыл бұрын
One more thanks.to.Google they always filter out.the best video we are looking.for . Should promote this video for all Excel power query users
@sanjay381996 4 жыл бұрын
Life safer and I'll have no more excel header nightmares ☺️☺️☺️🤸🤸
@LONG4WALK Жыл бұрын
another great trick. do you have another guider for multi sheet like this and combine together?
@AccessAnalytic Жыл бұрын
If connecting within a workbook then maybe this kzfaq.info/get/bejne/mbZ-ZZd_sJnDZmw.html will help, if connecting to an external workbook then the 5 minute mark here kzfaq.info/get/bejne/gdhjgZN809a1coU.html Also this post by my friend Gašper gives a few tips on creating a custom function, excelunplugged.com/2021/07/13/consolidate-multiple-excel-sheets-from-multiple-excel-files/#google_vignette
@pir4ta2007 4 жыл бұрын
This is the video that solved all my problems. Compliments.
@AccessAnalytic 4 жыл бұрын
Thanks for letting us know :)
@mikar636 4 жыл бұрын
Awesome man! Thanks for sharing!!
@AccessAnalytic 4 жыл бұрын
You're welcome
@josemiguelgonzalez2402 3 жыл бұрын
Awesome!! Thank you for make me save a lot of time!!
@AccessAnalytic 3 жыл бұрын
You’re welcome Jose
Access Analytic
Рет қаралды 108 М.
Goodly
Рет қаралды 42 М.
MyOnlineTrainingHub
Рет қаралды 222 М.
ExcelIsFun
Рет қаралды 34 М.
Leila Gharani
Рет қаралды 373 М.