Hi All,
Firstly I understand I could filter and remove blank rows but in this instance for automation I actually need a formula
My data looks as follows, what I require is a formula so that it on a new sheet only shows the numbers if the cell has a number it will show the number, if the cell as shown in A4 and A5 are blank the following number will actually be what is in A6. Final result I am seeking is shown further below
Existing Sheet
1234
3232
4242
<Blank>
<Blank>
6435
2342
<Blank>
4535
<Blank>
New Sheet
1234
3232
4242
6435
2342
4535
Firstly I understand I could filter and remove blank rows but in this instance for automation I actually need a formula
My data looks as follows, what I require is a formula so that it on a new sheet only shows the numbers if the cell has a number it will show the number, if the cell as shown in A4 and A5 are blank the following number will actually be what is in A6. Final result I am seeking is shown further below
Existing Sheet
1234
3232
4242
<Blank>
<Blank>
6435
2342
<Blank>
4535
<Blank>
New Sheet
1234
3232
4242
6435
2342
4535