Multiple header crosstab data clean up - Excel - Power Query

#excel #datacleanup #unpivot
Download sample file
efficiency365.com/wp-content/...
Related videos
Crosstab data clean up
• Convert crosstab data ...
Data handling best practices
• Excel Best Practices -...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency365.com/ptyt
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envato.com/
Created using Adobe Premiere: www.adobe.com/in/creativeclou...
AI based captions: videoindexer.ai (Microsoft service)

[@DM-ie9pm]

Nicely made with logical explanations.

[@efficiency365]

Thanks @DM-ie9pm Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzbin.info/www/bejne/qKWnnYKIgdKdoqc Excel Green Marks - Error Checking - Best Practices - kzbin.info/www/bejne/jpavpZ-wmZ6fiLs Excel Best Practices - Part 1 of 3 - Data Management - kzbin.info/www/bejne/qKPCYpuXa8xposU Excel Best Practices - Part 2 of 3 - Formulas - kzbin.info/www/bejne/oavCq3Ssgq6Bd80 Excel Best Practices - Part 3 of 3 - Analytics - kzbin.info/www/bejne/gH-1ZqyulLWaaqM 10 Excel Settings You Must CHANGE! - kzbin.info/www/bejne/rInVo4uagN59fM0 Automatic data clean up with Excel Flash Fill - kzbin.info/www/bejne/hGTTkKuVob2HlcU Instant Excel Audit, Comparison and Analysis - Inquire - kzbin.info/www/bejne/mXXHp4iQrbSIn9U Six powerful Excel Navigation Shortcuts - kzbin.info/www/bejne/mIOQqoCYfLWka5I Handle millions of rows in Excel - Slow to fast - kzbin.info/www/bejne/b2TLaKWIqLF5bbs Convert crosstab to tabular - Unpivot - Excel Power Query - kzbin.info/www/bejne/o4XXgKeQfZKhhK8 Cheers. Doc

[@rajeevgosavi4514]

Fantastic Sir, You have really converted a complex data into a properly redeable one. Thanks for sharing such a brilliant technique. Looking forward to more such videos on power query.

[@efficiency365]

Thanks @rajeevgosavi4514 Check out my other best practices videos as well. Task Management Best Practices - kzbin.info/www/bejne/envGqYOqqpKlmck Efficient Tasks Management using the New Planner 2024 - kzbin.info/www/bejne/oZjboq16nteqZ9E Microsoft Teams Meetings - 16 Best Practices - kzbin.info/www/bejne/omSlp6RjfpWbr5Y Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@tanakornpromthep9025]

Thanks for sharing

[@jasonjackson4555]

Great job. I should have watched this a week ago! I had some nasty cross-tab data from Tableau that I needed to clean up. It looked a lot like this. I eventually figured it out, but it took close to an hour 😅

[@efficiency365]

Thanks @jasonjackson4555 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzbin.info/www/bejne/qKWnnYKIgdKdoqc Excel Green Marks - Error Checking - Best Practices - kzbin.info/www/bejne/jpavpZ-wmZ6fiLs Excel Best Practices - Part 1 of 3 - Data Management - kzbin.info/www/bejne/qKPCYpuXa8xposU Excel Best Practices - Part 2 of 3 - Formulas - kzbin.info/www/bejne/oavCq3Ssgq6Bd80 Excel Best Practices - Part 3 of 3 - Analytics - kzbin.info/www/bejne/gH-1ZqyulLWaaqM 10 Excel Settings You Must CHANGE! - kzbin.info/www/bejne/rInVo4uagN59fM0 Automatic data clean up with Excel Flash Fill - kzbin.info/www/bejne/hGTTkKuVob2HlcU Instant Excel Audit, Comparison and Analysis - Inquire - kzbin.info/www/bejne/mXXHp4iQrbSIn9U Six powerful Excel Navigation Shortcuts - kzbin.info/www/bejne/mIOQqoCYfLWka5I Handle millions of rows in Excel - Slow to fast - kzbin.info/www/bejne/b2TLaKWIqLF5bbs Convert crosstab to tabular - Unpivot - Excel Power Query - kzbin.info/www/bejne/o4XXgKeQfZKhhK8 Cheers. Doc

[@canirmalchoudhary8173]

Use of flash fill instantly was amazing.

[@efficiency365]

Flash Fill research paper got many awards. kzbin.info/www/bejne/amOUmIhqbZerfKcfeature=shared

[@208935]

Really easy way explaination

[@efficiency365]

Thanks @208935 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzbin.info/www/bejne/qKWnnYKIgdKdoqc Excel Green Marks - Error Checking - Best Practices - kzbin.info/www/bejne/jpavpZ-wmZ6fiLs Excel Best Practices - Part 1 of 3 - Data Management - kzbin.info/www/bejne/qKPCYpuXa8xposU Excel Best Practices - Part 2 of 3 - Formulas - kzbin.info/www/bejne/oavCq3Ssgq6Bd80 Excel Best Practices - Part 3 of 3 - Analytics - kzbin.info/www/bejne/gH-1ZqyulLWaaqM 10 Excel Settings You Must CHANGE! - kzbin.info/www/bejne/rInVo4uagN59fM0 Automatic data clean up with Excel Flash Fill - kzbin.info/www/bejne/hGTTkKuVob2HlcU Instant Excel Audit, Comparison and Analysis - Inquire - kzbin.info/www/bejne/mXXHp4iQrbSIn9U Six powerful Excel Navigation Shortcuts - kzbin.info/www/bejne/mIOQqoCYfLWka5I Handle millions of rows in Excel - Slow to fast - kzbin.info/www/bejne/b2TLaKWIqLF5bbs Convert crosstab to tabular - Unpivot - Excel Power Query - kzbin.info/www/bejne/o4XXgKeQfZKhhK8 Cheers. Doc

[@ashusharma9439]

❤ thanks 🙏

[@efficiency365]

Thanks @ashusharma9439 Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Task Apps Comparison: kzbin.info/www/bejne/jJq6e3ywgrWEkMk Teams Meeting - Agenda, Action Points, Notes - kzbin.info/www/bejne/oWHXaZKjg9CAetk Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@jaswinderbhatti3352]

Thanks Sir

[@efficiency365]

Thanks @jaswinderbhatti3352 Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Task Apps Comparison: kzbin.info/www/bejne/jJq6e3ywgrWEkMk Teams Meeting - Agenda, Action Points, Notes - kzbin.info/www/bejne/oWHXaZKjg9CAetk Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@azwarmzafar]

Great one, thanks. but could not find the link of sample file.

[@efficiency365]

Hi Thanks for pointing out. Download sample file from here efficiency365.com/wp-content/uploads/2023/10/Multi-Header-Input.xlsx Also updated the description.

[@azwarmzafar]

Many thanks@@efficiency365