| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Duplicating Rows!!
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting all rows of data that have a value in a particular column | Excel Discussion (Misc queries) | |||
| Is it possible? | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Formula to change rows a different colour? | Excel Worksheet Functions | |||
| Insert rows, keep a formula? | Excel Worksheet Functions | |||
Threaded Mode
