Consolidating data

[a20222125]

I have an order sheet with numerous items listed. When an order quantity is entered i want the entire row with the item information to show up on a new excel sheet. So i end up with a 'summary' of the order that doesn't include any blank lines. I don't want to sort and copy them onto a new sheet. 

[#2]

Hi@a20222125 , If you have Microsoft Excel 365 or use Excel for the Web, you can use the FILTER() function. If you upload an example, it can be presented on it.

[#3]

I have Excel business 2019 so it doesn't look like the filter function is an option.

[#4]

@a20222125 

According to the Microsoft support page FILTER is available for Excel 2019.

[#5]

@OliverScheurich For some reason it's not an option for me. The only filter function that shows up is FILTERXML. is there a different formula?