I have an Excel worksheet with a few thousand rows. The first 2 columns look
as seen below. I need the Account # of every customer to be on every row.
As of now, the Account # is only on the First row and the rest of rows blank.
What type of formula can I create to replace the blank rows after the
account # with the account # that corresponds to customer. See below for
complete description.

Currently is:

Account Customer

P0182202 Bearid
Bearid
Bearid
Bearid

P38451US 360 OHIO DOT
360 OHIO DOT

P37544US 3DS BRIDGE PAINTING CORP. 3DS BRIDGE PAINTING CORP.

P01471US 4 D CORROSION

Should Be:

Account Customer

P0182202 Bearid
P0182202 Bearid
P0182202 Bearid
P0182202 Bearid

P38451US 360 OHIO DOT
P38451US 360 OHIO DOT

P37544US 3DS BRIDGE PAINTING CORP.
P37544US 3DS BRIDGE PAINTING CORP.

P01471US 4 D CORROSION