CHOOSECOLS and CHOOSEROWS are two new functions in Excel. They do what they say. They allow you to choose columns or rows from an array.
=CHOOSECOLS(array, col_num1, [col_num2],…)
Input required is the array, and then the column numbers that you want to display. (At least 1 is required, note the square brackets meaning that input is optional)
We have chosen just to see the first name (column 2 in the array) and age (column 5). Now, having the data right next to each other doesn’t make much sense, except as an example. A good way to use CHOOSECOLS would be to have the data displayed on a different sheet. This way you can have the “main” data, or all the data, or the input area on one sheet, and display just the data on another sheet that you need to see regularly. Or you could have different sheets for different people, or situations. A good general guide is to have the input on one sheet, and the data displayed in the way that you want it on another sheet.
CHOOSEROWS requires the same inputs as CHOOSECOLS, but will return the rows specified rather than the columns. Note that is the row of the array, not the row of the spreadsheet that you are inputting.
Combining CHOOSECOLS with FILTER function and SORT means that you can create blocks of data, containing just the right amount of information from a larger array.
If you put negative numbers in for the column or row numbers it counts from the right, or end of the array. You could also use this to rearrange the order of the rows or columns. These things can also be done in Power Query, which is an option worth exploring if you are needed to manipulate data in more complex ways.