Auto fill the Account number down to the next account number

[richmcgill]

I have a list of accounts where the account number does not fill in all of the lines of the report.
Is there a way to auto fill the Account number down to the next account number?
Make sense?

Report looks like this
Account Detail
123456789 123.66
ABC 123
Main
Home St
234567891 566.98
FL
Denver
Pilot

Need it to look like this
Account Detail
123456789 123.66
123456789 ABC 123
123456789 Main
123456789 Home St
234567891 566.98
234567891 FL
234567891 Denver
234567891 Pilot

 

[DanteAmor]

Try this:

varios 16jul2024.xlsm
	A	B	C	D
1	Acc	Det	Acc	Det
2	123	123.6	123	123.6
3		abc	123	abc
4		ma	123	ma
5		ho	123	ho
6	234	5	234	5
7		FL	234	FL
8		de	234	de
9		pi	234	pi
Hoja3

Cell Formulas
Range	Formula
C2:C9	C2	=IF(A2="",C1,A2)
D2:D9	D2	=B2

You can also fill in the cells in the same column, check the following:
fill blank cells

----- --
Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
----- --

 

[richmcgill]

Thank you for the help! Take care!