G
Guest
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
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