00:00This is how I managed to combine 1,000 worksheet into one using a VStack function.
00:05Select cell A1 here.
00:07I'm going to say equal VStack.
00:09The first argument on the VStack will be the header for the table.
00:13I'm going to select the table header like this, and after that, put a comma here.
00:17And the second argument on the VStack will be the data from the data set itself, like this.
00:23And then what you do is that you hold your Shift in your keyboard and select any of this worksheet
00:28here.
00:28I'm going to select all the way down to 13, and you should highlight the worksheet like this.
00:33After that, go back to your formula.
00:35Just replace 13 with 1,000 or maybe the last worksheet on your workbook and press Enter.
00:42And just like that, you have just combined 1,000 worksheet into one.
