Pivot data using Power Query - Key Value to Tabular |

Опубликовано: 25 Июль 2024
на канале: Efficiency 365 by Dr Nitin
1,070
34

Convert flat data with key - value pairs to tabular data. Simplify analysis.
Use Power Query - Pivot Column for conversion.

Download sample file and follow along...
https://efficiency365.com/wp-content/...

For corporate data analytics optimization session send a mail to [email protected]

#excel #powerquery #powerbi

Contents 📚
00:00 - The need
00:22 - Create Table
00:31 - Open in Power Query
00:54 - Add Index Column
01:15 - Assign row numbers
02:10 - Remove Index Column
02:16 - Pivot the data
03:01 - Check Data Types
03:16 - Import data
03:36 - Change input data

Related videos 📺
Append multiple columns to one column - Power Query -    • Append multiple columns to one column...  
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...  


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 :   / nitinparanjape  
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)