How do I write the formula in column B to display all values in column A but no zeros?

[arthurz11]

 

[SanjayGMusafir]

Check this and revert - You can modify range to your needs

=Filter(A:A,A:A<>0)

 

[arthurz11]

Check this and revert - You can modify range to your needs

=Filter(A:A,A:A<>0)

Thank you so much! I just wrote =Filter (A1:A10,A1:A10<>0) and BOOM! It worked perfectly.

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.