Pivot Table from Combined Data Multiple Sheets Excel 365

[@yassersaad757]

Amazing as usual. There is a revolutionary formula in excel which is unique. If you combine it with vstack, filter & sort you own the world

[@contextures]

Thank you, Yasser, and you're right - the new Excel formula are amazing!

[@dsuresht]

Fantastic way to name the spill range

[@contextures]

Thank you! I appreciate your comment

[@samirkapadia3423]

Super. Have been using VSTACK quite regularly. Was saving the stack data as a static value sheet and then making the pivot. Everytime the base data changed I would have to revise the static sheet. This trick will be a time saver👌👌👌

[@contextures]

Thank you, Samir, and I'm glad this trick will help you save time with your pivot table updates!

[@RobinsonCruezovic]

Good video! Can’t we transform the list into a table? Or is it not possible because of the vstack formula, so that we have name the range and use it for the pivot table?

[@contextures]

Thanks, Egor, and it's not possible, unfortunately. When you transform a list into a table, any formula in the header row is converted to a value.

[@accountsdata-n3z]

While inserting pivot table I got error "data source reference is not valid" why?

[@contextures]

If you're using my sample Excel file, be sure to include the headings when you select the first table.