Converting Horizontal Data to Vertical Using FILTER

Excel file teaching how to perform Converting Horizontal Data to Vertical Using FILTER operation.

Excel Source: Converting Horizontal Data to Vertical Using Filter

In the upper part, the data structure consisting of name, group and age values ​​is arranged horizontally, in this structure, only records belonging to the Fox group are selected with the FILTER function and the selected results are listed vertically using the TRANSPOSE function. Thanks to named ranges, formulas become more readable and flexible, and at the bottom, the name, group and age information of people belonging to the Tilki group are displayed collectively on a single vertical table.

Hope it is useful.