Delete certain N\A

[MasmaAbdulhamidli]

Hi. I have multiple rows with datas but also N\A. I need to delete N\A till there is beginning value by each row. I have sample, can you help? I need only delete N/A till becomes value. In "tomato" row there is no need delete N/A because of first value is number

apple	N/A	1	2
peach	N/A	N/A	3
tomato	1	N/A	3

 

[MasmaAbdulhamidli]

OK, my code will not work for you (it would have been really helpful to have that last image right from the very beginning!)
It looks like you just want to clear those values, but not delete/shift them over to the left.
I will need to re-work my code.

I'm so sorry for being to you trouble. Actually my problem is different. Maybe you can help me without N/A. May you give me a code for it? if there is no data for certain year there will be blank not N/A

 

[Joe4]

I'm so sorry for being to you trouble. Actually my problem is different. Maybe you can help me without N/A. May you give me a code for it? if there is no data for certain year there will be blank not N/A

I am confused...
How are you unsure of the data you are working with?
Why is your question changing so much?

And if the cell is already blank, what exactly are we doing?
There doesn't appear to be anything to remove if it is already blank?

 

[MasmaAbdulhamidli]

I am confused...
How are you unsure of the data you are working with?
Why is your question changing so much?

And if the cell is already blank, what exactly are we doing?
There doesn't appear to be anything to remove if it is already blank?

It worked. Your code for deleting N/A worked. Thank you very much. Sorry for I maked you angry) I am very grateful to you

 

[Joe4]

Not angry, just confused why things seemed to be changing significantly from the original question, and trying to understanding exactly what it was you were asking now.

Anyway, I am glad it worked for you.