Uncategorized

Learn how to Unpivot and Combine Data – From Multiple Sheets!

Posted on by Chandeep  -   

In this blog, we will learn how to unpivot and combine complex Excel data using Power Query – whether the data is spread across multiple sheets, in a cross-tab format, or contains totals and multiple headers. In this video, I will show you a step-by-step method so that you can easily clean and combine your data.

 

Learn how to Unpivot and Combine Data – From Multiple Sheets!

 

 

    Pop in your Name & Email to get the file!



    Thanks! Email sent. Don't forget to check your spam folder, just in case ;)



    Topics that I write about...



    Chandeep

    Welcome to Goodly! My name is Chandeep. On this blog I actively share my learning on practical use of Excel and Power BI. There is a ton of stuff that I have written in the last few years. I am sure you'll like browsing around. Please drop me a comment, in case you are interested in my training / consulting services. Thanks for being around Chandeep