I am an excel novice. I have started working with data strings of over 1000 rows. Some cells in a column have 0 values and must be replaced with the value of the cell to the left. Currently, I copy and paste to get the correct data. This takes hours. Surely that must be a better way or a function I can use? In the picture below. All 0 values in column E must be replaced with the value of the cell in column D. The same goes for column G, the 0 values in column G must be replaced with the value of the cell in column D. So. E4 0 replace with the value in D4. And G5 0 replace with the value in D5.
0 value in E4 replace with value of D4
Can anyone please help with a formula? I use Excel 2019 professional.