Returns the specified columns from an array.
Syntax
CHOOSECOLS(array, col_num1, [col_num2], ...)Arguments
arrayrequired
The array containing the columns to return.
col_num1required
The index of the first column to return.
col_num2optional
Additional column indices to return.
The CHOOSECOLS function extracts one or more columns from a given array or range. You can specify columns by their index numbers, and the function will return them in the order provided.
=CHOOSECOLS(A1:C3, 1, 3)→Returns columns 1 and 3 from the range A1:C3.Extracts the first and third columns from the specified 3-column range.
Select the target cell
Click on the cell where you want the extracted columns to appear.
Enter the formula
Type =CHOOSECOLS( followed by the range and the column numbers you wish to extract, then press Enter.
Yes, negative numbers count from the end of the array (e.g., -1 is the last column).