![]() ![]() Use HSTACK to combine two ranges horizontally.Use VSTACK to combine two ranges of data vertically.When you want to combine two ranges of data: Use TEXTSPLIT to separate the names into an array with “ “ (space) as a delimiter.Use “ “ (space) as a delimiter with TEXTBEFORE to extract the first name and TEXTAFTER to extract the last name.EXPAND - Expands an array to the specified dimensions.CHOOSECOLS - Returns the specified columns from an array.CHOOSEROWS - Returns the specified rows from an array.DROP - Drops rows or columns from array start or end.TAKE - Returns rows or columns from array start or end.Similarly, using CHOOSEROWS or CHOOSECOLS, you can pick specific rows or columns out of an array by their index.ĮXPAND allows you to grow an array to the size of your choice-you just need to provide the new dimensions and a value to fill the extra space with. Enter the TAKE and DROP functions! They enable you to reduce your arrays by specifying the number of rows to keep or remove from the start or end of your array. ![]()
0 Comments
Leave a Reply. |