Append multiple columns to one column - Power Query | @efficiency365
885 بار بازدید -
2 ماه پیش
-
Clean-up data quickly using the
Clean-up data quickly using the amazing #powerquery
Convert multiple column data into two columns using #excel or #powerbi with the UNPIVOT feature of Power Query.
Download sample file
https://efficiency365.com/wp-content/...
Contents 📚
00:00 - Intro
00:35 - Power Query
01:03 - Unpivot magic
01:54 - Rename columns
02:01 - Sort and Remove Duplicates
02:15 - Import data
02:29 - Refresh on input data change
02:53 - Auto refresh on file open
03:43 - Real Time Refresh
Related videos 📺
Split column by position - Power Query - Split column by position - Power Quer...
Consolidate multiple sheets - similar or unclean data - Power Query Sections - Consolidate multiple sheets - similar...
How To Check Data Quality Using Power Query? - How To Check Data Quality Using Power...
How to check data quality in Power Query - How to check data quality in Power Qu...
Merged rows - Data Clean up - Excel Power Query @efficiency365 - Merged rows - Data Clean up - Excel P...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
https://s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog
LinkedIn : LinkedIn: nitinparanjape
Twitter : Twitter: drnitinp
Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)
Convert multiple column data into two columns using #excel or #powerbi with the UNPIVOT feature of Power Query.
Download sample file
https://efficiency365.com/wp-content/...
Contents 📚
00:00 - Intro
00:35 - Power Query
01:03 - Unpivot magic
01:54 - Rename columns
02:01 - Sort and Remove Duplicates
02:15 - Import data
02:29 - Refresh on input data change
02:53 - Auto refresh on file open
03:43 - Real Time Refresh
Related videos 📺
Split column by position - Power Query - Split column by position - Power Quer...
Consolidate multiple sheets - similar or unclean data - Power Query Sections - Consolidate multiple sheets - similar...
How To Check Data Quality Using Power Query? - How To Check Data Quality Using Power...
How to check data quality in Power Query - How to check data quality in Power Qu...
Merged rows - Data Clean up - Excel Power Query @efficiency365 - Merged rows - Data Clean up - Excel P...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
https://s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog
LinkedIn : LinkedIn: nitinparanjape
Twitter : Twitter: drnitinp
Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)
2 ماه پیش
در تاریخ 1403/04/02 منتشر شده
است.
885
بـار بازدید شده