Populate a cell based on another cells condition

I am developing a chart where I would like only specific data to be viewed. or instance in one column i will have many cells populated with 0 and 1 cell populated with "2". I would like the chart to only populate the 2 but it populates all of the "0"s too. I need the cells to be blank so they do not populate in the chart but at the same time ther could be a condition where the 0 becomes a number and the 2 becomes a 0. Sorry if this is confusing but it is hard to write what I am looking for.

Basically I would like VB statement that will look at a range of cells (T35:T136) and if within this range anything other then 0 is populated I would like a destination cell to be populated with that number, if 0 leave that destination cell blank

I hope this makes sense.


thanks Steve

Let destination cells for T35:T136 is V35:V136.In V35 enter this and drag down.

=IF(T35=0,"",T35).

Thank you for your help, attached is the file i am working with.

Thanks but this did not achieve the results i need. It is really hard to explain what I am looking for.

Thank you, I uploaded a file as you suggested.