@@ExcelGoogleSheets could you do a video on this or link to one that you recommend? I know the query function could accomplish this. Hard to match column headers though. Keep think dget could get us there as well on sheets.
@ExcelGoogleSheets2 жыл бұрын
Here is one kzbin.info/www/bejne/enXPmWZ7g5uBjJo
@damian4601 Жыл бұрын
@@ExcelGoogleSheets maybe a part 2 for this? I know {,} and {;} can do the same. They are equivalent to function calls of Array_row and Array_literal.
@teoxengineer2 жыл бұрын
This functional tutorial is endless thanks for video. Apparently, the PQ calculation methodology began to occur in Excel formulas. It has been quite complementary to combine HSTACK and VSTACK formulas with the LAMBDA function. We are able to create this formula with the Office365 with the EXPAND formula. What I want to ask, Can we combine different tables and show the combined tables, repeat to pivot as well as showing which table of these data is coming from?
@usmanahmad77585 ай бұрын
Can we add HANDLEBLANK before VSTACK function only once??
@TheOligopeptide2 жыл бұрын
Thank you that is really interesting. Excel is starting to look better and better compared to google sheets since I don't have any programming skills (I know I should start learning at least one programming language being that it is the future). One question though....when you create those custom formulas in a excel spreadsheet, will you be able to to use those in new workbooks or you have to recreate them each time you are working in a new workbook?
@ExcelGoogleSheets2 жыл бұрын
You'll have to recreate them in other workbooks.
@nikithau14656 ай бұрын
Hey, can we get the new results in end of data, using vstack
@eiger672 жыл бұрын
Hi, thank you for this very full of contents tutorial, by the way i don't have both functions HSTACK & VSTACK in the Excel version i use. May i ask you whitch version you do use? Thank's again