Excel VSTACK - Combine Multiple Tables (Ranges) to a Dynamic Master Sheet with VSTACK Function

[@IvanCortinas_ES]

Excellent tutorial. Thanks for telling it in such detail.

[@ExcelGoogleSheets]

Thanks!

[@nguonchandy]

@@ExcelGoogleSheets how to get this function?

[@user12345654]

Great and much needed tutorial !

[@richardhay645]

You can put you desired header as the first item in the VSTACK instead of copy paste. I NEVER do a VSTACK without converting all data to tables. I like your demonstration of LAMBDA. Too often LAMDA is taught using pointless, inefficient constructs.

[@compjotter2556]

As usual an enlightening explanation of a new function.👍Will this function also be available in the free excel online version?

[@ExcelGoogleSheets]

Can't know for sure, but most likely at some point it will be.

[@compjotter2556]

@@ExcelGoogleSheets I'm curious what the update speed of Excel is. 😏

[@ExcelGoogleSheets]

It varies, but mostly between 6 months to a year from initial insider version.

[@teoxengineer]

very cool. Like powerquery editor

[@vivianrichmusic]

Instead of using multiple IF statements to remove 0s for blanks you can use 1 SUBSTITUTE formula instead and have VSTACK nested inside.

[@ExcelGoogleSheets]

What exactly would that substitute formula look like?

[@datahrd346]

Hay Sir, this is very best and so functionally uf could be use in google spreadsheet, can it???

[@user-om6tz9us7z]

Ticket create date : 05/01/2024 09:30 AM, Ticket closing date: 07/01/2024 12:30 PM, I want the total duration but after 09 pm to 09 am i dont want to count the hours, whats the excel formula. please help.

[@mrCetus]

how do you get these functions?? I don't even have lambda. How do I install that particular version?

[@ExcelGoogleSheets]

Assuming you are on office 365, under File->Account you have options for updates. If you want all the most recent cool toys you can join Insider program available again under File->Account. Otherwise you can wait a bit and just do a regular update.

[@rajeshr8887]

Interesting…can the header of the first table be part of the range? That way I don’t have to copy paste the header.

[@ExcelGoogleSheets]

I like to keep my data separate, but, yea, it should work.

[@edwinrondina5491]

Hi sir, is this possible in google sheet? by the way, excellent tutorial as always!

[@ExcelGoogleSheets]

I've done something similar for Google Sheets here kzbin.info/www/bejne/p2nEqIGJjrOXp5Y

[@Al-Ahdal]

1st comment and like

[@ExcelGoogleSheets]

You rock!

[@mdrumi629]

Sir, is Vstack function available in Google Sheets?

[@TheShocobo]

this command was first announced by MS on March 16... Seems like MS team is trying to differentiate it from google sheets by creating new functions available only in Excel.

[@ExcelGoogleSheets]

No. Unfortunately Google Sheets hasn't been releasing much lately other than design tweaks.

[@mdrumi629]

@@ExcelGoogleSheets Sir, is there any way to achieve the functionality of Lambda function in Google Sheets?

[@ExcelGoogleSheets]

No.

[@iiiiii-w8h]

how do you get these functions?? I don't even have lambda. How do I install that particular version?

[@ExcelGoogleSheets]

Assuming you are on office 365, under File->Account you have options for updates. If you want all the most recent cool toys you can join Insider program available again under File->Account. Otherwise you can wait a bit and just do a regular update.