Power Query Split Columns and Rows in Excel | Split Data into Rows with Power Query

Рет қаралды 12,896

3 жыл бұрын

Power Query Split Columns and Rows in Excel | Split Data into Rows with Power Query
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 #powerquerysplitcolumns#innozant #powerquerysplitrows

Пікірлер: 77

@hemantsingh9966 Жыл бұрын

In each video, I feel your love of teaching Gurujii. Nobody in this universe can teach like you. Pranaam 🙏🙏🙏

@Innozant Жыл бұрын

Thanks Hemant ,aaapka yr feedback bht mayne rakhta h mere liye

@hemantsingh9966 Жыл бұрын

Gurujii... It is a public platform. Hence, I can't reveal my identity here. I could give you my learning experience with you in written through email or some other sources. I believe this feedback would help you in your business. I have dropped an WhatsApp message.... Pranaam Gurujii.

@Altaf_Alam Жыл бұрын

Like your all videos ❤ tip top contents 😊

@acommonman155 Жыл бұрын

Brilliant Guru Ji 🙏🙏 very effective for my office day to day activity

@Innozant Жыл бұрын

Thanks dear❤️👍

@mjaved701 3 жыл бұрын

Great sir, this time too much time has been taken by you for uploading power query lecture. Credit🤗🤗🤗 to your efforts. Dil se

@Innozant 3 жыл бұрын

Thanks ❤️🙏Javed sahab

@GaganDeep-mj5hi 2 жыл бұрын

You are Great teacher

@manaskumardas1683 2 жыл бұрын

Very nicely explain sir, many many thanks for sharing knowledgeable videos absolutely free.

@sandeepaswal8944 3 жыл бұрын

Sir Very Professional way of teaching. Thank you for creating this tutorial.

@Innozant 3 жыл бұрын

Thanks Sandeep ji .👍❤️❤️❤️

@khalidalisubhanallah2947 3 жыл бұрын

Very knowledgeable video Bundle of thanks 👍♥️

@Innozant 3 жыл бұрын

Thanks bKhalid sahab🙏❤️

@jayantabhattacharyya628 3 жыл бұрын

Dear Sir Now I am gradually feeling the beauty of power query through your tutorial. I hope more amazing features of power query I am going to learn from your tutorials. Thanks & Regards Jayanta Bhattacharyya

@Innozant 3 жыл бұрын

Thanks Jayanta...sure dear🙏❤️

@deepakchauhan4974 Жыл бұрын

What a brilliant approach sir, this helped me out thoroughly for one of the my complex project. Pranam Sir 👏🏼

@Innozant Жыл бұрын

Thanks Deepak..Keep Learning.Keeo Exploring 👍❤️

@SWARAJ81 4 күн бұрын

Thank you sir 👋👋👋👋👋

@GaganDeep-mj5hi 2 жыл бұрын

Very nice content

@shrikantbadge3978 Жыл бұрын

Amazing sir thank u

@satishojha6240 3 жыл бұрын

Excellent video sir thanku 😇😇😇😇

@Innozant 3 жыл бұрын

Good Morning .. Thanks Satish Ji

@eighttech 5 ай бұрын

Thanks ❤

@nageshwarlal9967 3 жыл бұрын

Sir, please upload more powerful powerful feature videos of poweer query frequently...... I m your big fan sir........ You are the best teacher and best content provided by you on internet

@Innozant 3 жыл бұрын

Thanks Nageshwar Ji..Sure dear🙏❤️

@hbp7633 3 жыл бұрын

Bhaai tu Excel ka Bhagvaan hai. I salute you sir. You have such a great zeal on your work. After all work is worship.

@Innozant 3 жыл бұрын

Thanks for your lovely appreciation dear..God bless you..have a greay day🙏❤️

@hbp7633 3 жыл бұрын

@@Innozant Sirji, is there any way where we can download / add-in Office 365’s some functions to office 2013. Fxs like Filter, Let, Sort etc... There must be a way... And thank you for your comment too.

@TheSuvankarKundu 3 жыл бұрын

After sooooo long.. We wait for ur vds everyday.. Pls upld vds frequently..

@Innozant 3 жыл бұрын

🙏❤️

@veerdhadra 3 жыл бұрын

Superb...!!

@Innozant 3 жыл бұрын

❤️❤️

@rakeshmlearningentertainme6099 2 жыл бұрын

thanks video

@hsgusain2054 Жыл бұрын

Thanks sir

@Harish.Prasad.Semwal 4 ай бұрын

Very nice sir.

@meditationmusic6482 3 жыл бұрын

Thanks sir ji

@Innozant 3 жыл бұрын

Thanks dear🙏❤️

@debasischakraborty7445 7 ай бұрын

Thanks lot of thanks

@hemlatasharma2082 3 жыл бұрын

Like ur all videos sir

@Innozant 3 жыл бұрын

Thanks Hemlata..God bless you.Happy Learning ❤️❤️

@hemlatasharma2082 3 жыл бұрын

@@Innozant sure sir,, thanks

@aqeelahmadengr3 3 жыл бұрын

Well-done

@Innozant 3 жыл бұрын

Thanks 🙏❤️

@durgeshrai8938 3 жыл бұрын

Great sir

@Innozant 3 жыл бұрын

Thanks Durgesh Ji🙏❤️

@durgeshrai8938 3 жыл бұрын

Sir again aap freser mis ka vidio upload kre Technical & machine round 🙏

@jaynarayan1963 3 жыл бұрын

Nice👍👍

@Innozant 3 жыл бұрын

Thanks Jay❤️🙏

@vivekthakur2334 3 жыл бұрын

Nice Sir

@Innozant 3 жыл бұрын

Thanks Vivek ji🙏❤️

@heeralalkumawat2132 Жыл бұрын

❤❤❤❤❤❤❤

@RahulRoy-po9ct Жыл бұрын

🙏

@meriawaazhindi5217 Жыл бұрын

❤️❤️❤️❤️

@arshadalam6109 2 ай бұрын

Good❤

@abhinav10x Жыл бұрын

Thank you, 2016 me Split me options sirf 2 he hai

@harishpandey168 3 жыл бұрын

Very Nice sir...I have a querry...Suppose in a column..where few fig are positive and few are negative..Below that I want to sum only the positive fig...Whether this can be done...Plz tell sir...😊😊

@Innozant 3 жыл бұрын

Criteria me "(>0) pass kar dijiye🤗🙏❤️

@mayurt4628 11 ай бұрын

How to get personalized training .. please advise

@Innozant 11 ай бұрын

Sorry we don't provide personalized training,You may join our live or offline batches .For more information kindly visit Innozant website

@RomanReigns-oh2dz 3 жыл бұрын

Hii sir Do you teach C language too?

@Innozant 3 жыл бұрын

Not now..

@mahaminmondal6248 3 жыл бұрын

Sir, I am facing an issue in Excel. I have some phone numbers on sheet no. 2 and I want to paste those phone numbers to the empty cells on sheet no. 1 without overwriting the existing phone numbers on sheet no 1. I want to paste the phone numbers from sheet no 2 to the blank cells only on sheet no 1

@Innozant 3 жыл бұрын

Share your sheet with detail query explanation in @innozantofficial telegram id

@mahaminmondal6248 3 жыл бұрын

@@Innozant Sir, I have sent that to the telegram id you have mentioned

@syedasifimamrizvi 3 жыл бұрын

Thanks Sir, aap ki video mereleya very helpful hai. aapne marks% basis per if ka function lagana sikhya bahut helpful raha mereleya but sir mera ek question hai, sir kisi bhi student ko ek bhi subject agar 33% se kam number aye to use "fail" show karna hai jabki us student total %> 33 or >45 >60 hai tab bhi. sir maine karne ki koshish ki par nahi hoo raha hai sir plz help me.

@syedasifimamrizvi 3 жыл бұрын

Sir main 50% kamyab hoo gaya hoo. subject ka aur total marks ka criteria full fill ho raha hai to results 1st, 2nd...... show kar raha hai but subject ka criteria full fill nahi hone per who False show kar raha hai but mujhe result Fail show karna hai. plz sir help me plz.