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👌👌👌
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?
Fantastic way to name the spill range
Thank you! I appreciate your comment
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
Thank you, Yasser, and you're right - the new Excel formula are amazing!
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👌👌👌
Thank you, Samir, and I'm glad this trick will help you save time with your pivot table updates!
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?
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.
While inserting pivot table I got error "data source reference is not valid" why?
If you're using my sample Excel file, be sure to include the headings when you select the first table.