Create Excel Pivot Table from Multiple Sheets: The FASTEST Way
Vložit
- čas přidán 2. 07. 2024
- Create a Pivot Table from Multiple in Sheets in Excel. Are you struggling to consolidate data from different spreadsheets? Want to simplify your data analysis and reporting? You've come to the right place! In this video, I’ll show you the fastest method to create a pivot table in Excel using data from multiple sheets, with the help of the powerful Power Query Editor. This guide is perfect for Excel users of all skill levels looking to enhance their data management capabilities.
Download practice file: go.teachers.tech/pivottable_m...
I0:00 Introduction
0:56 Create tables
2:03 Launch Power Query Editor and add source
3:13 Merge data into one query
4:50 Close and load to Pivot Table
7:16 Build relationship between tables
Just what I was looking for! So easy to understand. Thank you so much. I keep an month by month tally of my contract work but really wanted to find a way to combine it. This was perfect.
I cant open the file I'm using in power query. I get an error saying Unable to Connect because the file is being used by another process. How am I to pull the sheets?
I'm getting this error too and I can't get past it!
Teacher before i watch your lesson really u deserve a 100 like thanks a lot for help me to improve myself in our company 🌹🌹🌹🌹
Thank you!
@@TeachersTech Truth be told٫thank you very much for your wonderful effort.May God bless you.🌹
Great content! ✨🔥 Your perfect video title called my attention in my Google search. I followed all the instructions and it all worked flawlessly 🙌🏾 The part explaining the relationship was the cherry on top of the cake!!! Thanks heaps from Sydney, Australia 🦘
Simple and essay to understand
I love this!!!
It was amazing, thanks a lot ❤
Welcome 🙏
You know that you helps thousands People one them its me !.thanks from Dubai
You’re welcome!
@@TeachersTech can you answer the questions below about getting the error file in use?
thank you
I enjoy every single video you drop but I need help creating a questionnaire web app using excel source file
In my use case, both worksheets are in one Excel doc, and I want to include the pivot table in the same Excel doc. When I follow the instructions for pulling the source in Power Query, I get an error that the document is being used by another process. In the video, it looks like you're working in the same Excel doc. Thoughts?
Yes exact same issue, great video very well explained, and then get the same error
i am not getting pivot table report option under close & load tab