Formula (not vba) to delete row if cell blank on imported data

Hello Excel Experts ... I have reviewed the Forum for an answer to this puzzle but I've found nothing. I would appreciate your thoughts/ideas. Thank you!

I have a database that exports data into an Excel file. I place the data into sheet 2. In sheet 1, I then manipulate the data found in sheet 2 to give me the exact form I'm looking for before importing it into yet another database.

I am trying to find a formulaic way to delete a row that does not have a value in a certain column. So if 30 rows are imported, and cells D7 and D19 are empty, I would like to delete the row altogether through a formula (not vba).

Can you help? Thank you!

Ouch! Okay, thank you! (I guess that's why I could not find it???)

This forum is awesome!

Thank you for your reply. Although that will work, I am looking for an automated approach because I don't want my users to be 'fussing' with the file. I would just like to have them read the finished product after the formuli do their work. Thanks!

There are 72 columns and no more than 50 rows. I think I see what you are saying. In essence, if D7 is blank I can then blank all fields in that row which will appear like an empty row in between other rows. Hey, that could work for me because I don't have a problem with the row being there if it's all blank. Not perfect but pretty darn close. Thanks!

Unfortunately, no. The end result is the file will be imported into a database that will 'see' the data in the field. I will need to actually make the fields blank (e.g., ""). With 72 columns it's a bit onerus but if it will work it's probably less time then looking for other solutions. Thanks, again for your persistence.

I know it is marked solved and may be too late, but if you just want to delete the row without shifting up,

For cell A1

Formula:

Please Login or Register  to view this content.

If you actually want to shift it up, I started out with this but need more information; do you want the original data of a cell one row below if D is empty, or the data after the row is shifted. in the other word, if D1 is empty and D2 is "ABC", D3 is "CDE", do you want D1 to show "ABC" then D2 to show "CDE", or D1 to show "ABC", D2 to still show "ABC". In vba, I am more than sure it is the first option, but i wasn't sure what you are trying to accomplish using formula so I had to ask...

Formula:

Please Login or Register  to view this content.

If you are to show data of actually shifting up, then the beginning of the formula has to include COUNTBLANK for Column D till that row, and if 0, use above formula, if 1, then shift the above formula to refer one beneath, and so on.

Jake