Removing blank rows from rows of data

[cmboyer05]

I am a newer excel user and have done some searches to find what i need, but no luck I am sure this is simple so appreciate any help.

I Need formula that refers to example sheet 2 a3:f400 of 6 columns, 400 rows of text data and returns values to sheet 1 but removes any blank rows and only shows the rows that have a value. I tried IFERROR and must be doing something wrong.

 

[Joe4]

Welcome to the Board!

You may be able to use the new FILTER function to do it (FILTER function - Microsoft Support).
Is there a specific column that we can look at, that is only blank if the entire row is blank?

 

[cmboyer05]

Welcome to the Board!

You may be able to use the new FILTER function to do it (FILTER function - Microsoft Support).
Is there a specific column that we can look at, that is only blank if the entire row is blank?

The data will change daily, so I would like the new daily values to automatically update on this spreadsheet versus filtering. There will be 22 sheets that I will have to filter I prefer not to do that! if I can figure out the formula in the one I can use in the other sheets.

There will be the same 6 columns daily, but new data will populate and the rows that have data all 6 columns will have data, there will be no blank columns, only blank rows. I used a simple IF formula to get the products broken out. BTW thank you for responding!!!

 

[cmboyer05]

there will be blank columns/rows...but all the 6 columns in the row will be filled out if the data is there, make sense?

 

[Joe4]

Note I did NOT recommend using Filtering, but rather the new FILTER function. It is a formula, that you only need to enter in one cell, and it fills all other needed cells automatically.

Here is an example, like you have shown. The original data in in columns A-F, and I put this formula in cell H4.

=FILTER(A4:F11,A4:A11<>"")

And here is the proof of concept!

 

[cmboyer05]

Note I did NOT recommend using Filtering, but rather the new FILTER function. It is a formula, that you only need to enter in one cell, and it fills all other needed cells automatically.

Here is an example, like you have shown. The original data in in columns A-F, and I put this formula in cell H4.

=FILTER(A4:F11,A4:A11<>"")

And here is the proof of concept!
View attachment 123952

Yes I realized after I posted you didnt mean filter, you meant the filter formula!!!! Thank you so much!!!

 

[Joe4]

You are welcome.

Please Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.