Deleting empty cells using PowerQuery

[lezawang]

Hi
I know how to delete empty Rows using Power Query. But I thought I also can delete empty cells. I remember I did it once but I do not see that option now. Power Query would insert Null in these empty cells. For example I have this table and there are some empty cells I want to delete? Thank you very much.

Name	Dept	City	Ph#
John	IT	City1	123
Mary		City2	222
David	HR		444

 

[GraH]

Are you sure, because that would be strange since PQ works on columns or records (rows). I do not see how to accomplish this trough the UI.
In your example what would be the expected result?

(I assume you know to replace blanks by nulls is simply using the replace value feature.) But that's not what you are after here.

 

[lezawang]

I think I had one column table and deleting empty rows means in this case deleting empty cells. I think that is what I tried beofore. Thanks for the confirmation and also very thanks for the replace feature. I did not know I can do that. Actually that can be the answer to spot these empty cells. Thank you again.

 

[GraH]

Thanks for the feedback. Glad I could help.