Merge Columns with Power Query | Advanced Concatenate | Power Query Step by Step

Подписаться 150 тыс.

Просмотров 13 тыс.

50% 1

Merge Columns with Power Query | Advanced Concatenate | Power Query Step by Step
Excel Power Query Playlist Link- • Excel Power Query
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#powerquery #mergecolumns#innozant #powerquerytutorial

Опубликовано:

8 июн 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 96

@nishant9001 13 дней назад

Thank you so much sir

@gauravbanerjee7891 3 года назад

Ek aur bahut bahut majedar video...... thank you sir 🙏

@Innozant 3 года назад

Thanks Gaurav Ji.. Happy learning ❤️🙏

@Altaf_Alam Год назад

Best content as always 🔥❤

@Herukamahesh Год назад

Great bro 🤞

@kishorpanara4191 3 года назад

Sir aap super se bhi uper ho Thank you sir

@Innozant 3 года назад

Thanks Kishor..Happy Learning 🙏❤️

@srikanthchs7255 11 месяцев назад

Excellent

@ankitjindaljulana 3 года назад

Thank you sir You are the best teacher

@Innozant 3 года назад

Thanks Ankit .🙏❤️

@jayantabhattacharyya628 3 года назад

Dear Sir Another superb video on power query merge columns. Power query certainly adds power to our excel knowledge & also your way of teaching. Thanks & Regards Jayanta Bhattacharyya

@Innozant 3 года назад

Thanks Jayanta..hope you like this power series❤️🙏

@sonpurkesone4072 Год назад

Superb sir

@durgeshrai8938 3 года назад

Tnkhu sir🙏🙏

@hsgusain2054 3 года назад

Thanks sir....

@Innozant 3 года назад

Thanks

@manojkumarsingh3385 3 года назад

Bahut khubsurat sir 🙏🙏🙏🙏

@Innozant 3 года назад

Thanks Manoj Ji ❤️🙏

@eighttech 5 месяцев назад

Thanks you 🙏

@satishojha6240 3 года назад

Again very effective video thanku sir 🙏🙏🙏. Good night

@Innozant 3 года назад

Thanks Satish Jim.tc...good night🙏❤️

@createyour6681 3 года назад

Very great sir

@Innozant 3 года назад

Thanks 🙏❤️

@NitinSharma-sr5rn 10 месяцев назад

Speechless and stunned with your extraordinary knowledge and grip in your core area Its request from my side plz give us SQL course

@sandeepaswal8944 3 года назад

सर मुझे बहुत ख़ुशी होरी है की मै आपसे Power Query सीख रहा हूँ | आपका हर ज्ञान मेरे लिये अनमोल है | मै आपके हर विडोज़ की बहुत प्रैक्टिस करता हूँ | आपका दिल से धन्यवाद |

@Innozant 3 года назад

Thanks Sandeeo Ji .God bless you .hope aap enjoy Kar Rahe hain power query ko🙏❤️

@aqeelahmadengr3 3 года назад

Well-done

@Innozant 3 года назад

Thanks ❤️🙏

@aishwaryajain5322 5 месяцев назад

Amazing sir

@sonukumar-xp5sd 2 года назад

U r awesome bro..👌👌👌👍👍👍

@Innozant 2 года назад

Thanks Sonu Ji..Happy learning ❤️

@RahulChauhan-ll9pu 3 года назад

Zebardest

@Innozant 3 года назад

Thanks dear🙏❤️

@pramodbhavsar4488 3 года назад

Advance concatenate merge coloum in power query is explained three type example is. Very nicely explained by you .thank you Sir.

@Innozant 3 года назад

Thanks Pramod Ji❤️❤️🙏

@khalidalisubhanallah2947 3 года назад

Very Helpful Video Sir g

@Innozant 3 года назад

Thanks dear❤️🙏

@ManishSingh-dn3ro 3 года назад

After suffering from covid..I'm back.. Sir you are really awesome..

@Innozant 3 года назад

Oh...Now you fine?take proper rest for few days then restart your Learning journey❤️🙏

@rajpandit3807 2 года назад

Very Nice

@Innozant 2 года назад

Thanks dear❤️👍

@pa2happiness13 3 года назад

Ye Project Clear Hai Sir ♥️🙏 Fir V Ek Baar Practical Karunga Kuch Problem hoga tho Aap hai naa

@Innozant 3 года назад

Good

@RahulRoy-po9ct Год назад

🙏

@vijaykumarjain3222 3 года назад

Nice sir

@Innozant 3 года назад

Thanks ❤️🙏

@onlyexcel493 3 года назад

ETl Tool ki to sir baat hi kuch alag he

@Innozant 3 года назад

👍🙏❤️

@aniketsharma7307 2 года назад

Sir when I was adding custom column and using merge text and number with the help of text.from then getting error the name "text.from" was not recognize. Make sure it's spelled correctly. How can we fix?

@rakeshmlearningentertainme6099 2 года назад

Nice vifeo

@Innozant 2 года назад

Thanks

@faisalmd283 3 года назад

Hi sir, small doubt in excel, why do we get blank in the pivot table when their is no blank in the data. and the same when we filter data blank will be shown but actually their is nothing like that. I would request you to tell why it reflects and how to remove blanks. Thanks in anticipation.

@acommonman155 Год назад

As always very nicely explained by you GURUJI. But I have a question ? This can also be done by using flash fill (CTRL+E) in excel ?

@Innozant Год назад

Flash fill is static dear.. 😊

@Funnysshorts2m 3 года назад

Agar sir Vertical me alag -2 cell me address hai to ushe kaise merge karte hai Exp A-456 Gulaothi Bulandshahr-203408

@dineshchaudhary7962 2 года назад

Sir, agar hum pehle hi sales wale column ka data type change kar de to phir to errore nhi aaga na

@kirankumaryadav2516 3 года назад

Sir For time comparison in a column the time format is in [H]:MM:SS and for to get results using IF function for greater than 24 hours as beyond time and less than 24 hours what formulae is to be used. Please reply sir.

@Innozant 3 года назад

What output you are looking for? Kindly explain..Are you talking about power query function or excel

@kirankumaryadav2516 3 года назад

@@Innozant Not about power query. Ex if we have times in columns like 34:34:43, 46:57:54, 12:32:56, 44:56:32, 08:45:46 I want to get result using IF function as for greater than 24 hours to come as "Beyond time" and less than 24 hours as "Within time"

@anilnayak3328 3 года назад

Thank you so much sir add column from example se hoga sir.

@Innozant 3 года назад

Yes.dear

@onlyexcel493 3 года назад

Frist viewer

@Innozant 3 года назад

🙏❤️

@anildkumble4988 3 года назад

Namaste ji I wanted to merge Name & Age column. I typed like this in the custom column formula.. =[name]&":"&text.from([age]) . its giving error.....it says...text.from is not recognised.. kindly help me... do i need to change settings

@Innozant 3 года назад

Why you pass range over there

@ubaidillahmuhammad20 3 года назад

nice. please put it - Download File for Practice -Direct Link

@Innozant 3 года назад

Will updare it by today

@ubaidillahmuhammad20 3 года назад

Download File for Practice -Direct Link Updating soon. WHERE IS IT?

@soumyaranjan4068 3 года назад

Hello sir i am a basic data entry operator and i want my carrier growth in this field..what i need to do...please help

@Innozant 3 года назад

Soumya... Thanks for showing your interest in MIS& Data Analytics field .Start your Learning journey from Playlist Basic Excel onwards

@soumyaranjan4068 3 года назад

@@Innozant thanku sir

@syedasifimamrizvi 3 года назад

Thanks Sir VBA ka class start karen

@Innozant 3 года назад

Power series ke baad hi hoga

@MrModha-ww5wk 3 года назад

Unable to show power query editor

@Innozant 3 года назад

Why dear

@paramsingh383 3 года назад

Sir power query excel se alag topic hai na?!

@Innozant 3 года назад

Usi ka hissa hai dear...but pehle excel finish kijiue uske baad power query ,power pivot and power BI seekhna hai.ok

@paramsingh383 3 года назад

@@Innozant ok sir thanxxxx

@kashisharora4563 3 года назад

Sir, please upload updated assignments files on Google drive.

@Innozant 3 года назад

Which one Kashish..Oh may be Example file is not updated ..Will update it by tomorrow Dear

@kashisharora4563 3 года назад

@@Innozant Thnku sir

@bhawanimurariya8934 Год назад

Guru Ji After one Merge Continue showing Error

@Innozant Год назад

Error ?

@bhawanimurariya8934 Год назад

@@Innozant Guruji I want to make 4 Concatinate in same sheet after one is done rest of three for its showing error

@onlyexcel493 3 года назад

Sir pdf file ko power query me kese laye

@Innozant 3 года назад

Data import. Hai to option

@onlyexcel493 3 года назад

Please ek video banado sir pdf ke regarding.. Kese fetch kre power query me

@mayankkumarbansal4323 3 года назад

Basic se sikhaana kab chalu kroge

@Innozant 3 года назад

Matlab ? Kaunse course ke basic se ki baat kar re hain..Jitne bhi playlist hain saaare basic se hi sikhaya ja raha hai dear❤️🙏

@mayankkumarbansal4323 3 года назад

@@Innozant jahaan se excel ki suruaat hoti hai. Excel tutorials for noob. Aap video me bahut sort cuts key use krte ho jisse thodi confusion ho jaati hai. Zero se all excel tutorials Like new computer studant Pls.. sir🙏

@Innozant 3 года назад

Dear Basic Excel Playlist ke pehle video se seekhiye...aur ydi abbi basic bhi nhi kiya hai to pehle MS Word seekhen..uska alag se bana hua hai playlist..uske baad excel se start karen seekhna

@lifeforknowledgelk992 2 года назад

Sir I want to merge two file through power query. But I pull them side be side but not able to merge them in a single file. Kindly give me your email I want to talk you.