In order to arrange information according to a particular format in Excel worksheet, you need to use the filter function.
In Excel, the FILTER function is used to filter a range of data depending on the criteria you define.
The function is within the Dynamic Arrays category.
As a consequence, an array of values spills onto a range of cells, beginning with the cell where you write a formula.
Learn more about excel:
https://brainly.com/question/15079468
#SPJ1