Convert Summarized Table To Proper Data Set With Power Query!

preview_player
Показать описание
Another Power Query Demo! Let's see how we can transform a cross-tab report into a more simple data set

Original video:

Follow me on Twitter:
Sponsor:
Рекомендации по теме
Комментарии
Автор

Sir i come cross an issue but no solution yet. I need only starting alphabet from left in few scenario like DAM001 will be DAM, DD03010B1 to DD, EP10130A10 to EP, DAMR381K2 to DAMR.
I tried many ways but still not get correct answer in Power Query.
Any help

shoaibrehman
visit shbcf.ru