Pull Data and Ignore Blank Rows

[dgoodrid]

Hi i have a spreadsheet with multiple mahcines and Critical updates and dates on them, There are gaps between data as its pulling all the data from other sheets, so what i need it to copy the data to another sheet but ignore the empty rows and sort them by machine name and then dates

below is just a extract and copy of data as some other data thats sensative (sorry)

Office LTSC Pro Plus 2021

 

[SanjayGMusafir]

Office LTSC Pro Plus 2021

Update same in your profile too for others to help you efficiently.

Use can use FILTER Function to pull data without blank rows, if you are using Office 2021

 

[SanjayGMusafir]

Try this in Cell i7 and revert

=FILTER(B7:E10000,B7:B10000<>"")

 

[dgoodrid]

OK thanks ill take a look at this option

 

[dgoodrid]

Yep works perfect, thank you so much

 

[SanjayGMusafir]

Yep works perfect, thank you so much

Glad to help you and thanks for the feedback.