Hello All--My issue is I have about 26,000 rows of data. Of these 26K rows I have unique identifiers in Column A. Row 1 Column A has Unique identifier 3000600850 then has no value in the next 4 rows (entered blank for example). After those 4 rows is 3000600944 followed immediately by 3000601323 and 3 more blank rows. This happens throughout the rest of this worksheet until the 26000 rows.
Those blank rows need to be populated with the value immediately before those rows of blank cells. For instance with 3000600850 the 4 blank rows after need to be populated with 3000600850 until I get to 3000600944. Does anyone know a formula I can add in a column before that would populate those cells--I'd rather not manually go through and copy down.
Thank you all for the help!!
Examples:
Current State
[TABLE="width: 123"]
<tbody>[TR]
[TD]3000594794
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]3000600944
[/TD]
[/TR]
[TR]
[TD]3000601323
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]3000601327
[/TD]
[/TR]
</tbody>[/TABLE]
Desired Outcome
[TABLE="width: 112"]
<tbody>[TR]
[TD]3000594794
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]3000600944
[/TD]
[/TR]
[TR]
[TD]3000601323
[/TD]
[/TR]
[TR]
[TD]3000601323
[/TD]
[/TR]
[TR]
[TD]3000601323
[/TD]
[/TR]
[TR]
[TD]3000601323
[/TD]
[/TR]
[TR]
[TD]3000601327
[/TD]
[/TR]
[TR]
[TD]3000601330
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
Those blank rows need to be populated with the value immediately before those rows of blank cells. For instance with 3000600850 the 4 blank rows after need to be populated with 3000600850 until I get to 3000600944. Does anyone know a formula I can add in a column before that would populate those cells--I'd rather not manually go through and copy down.
Thank you all for the help!!
Examples:
Current State
[TABLE="width: 123"]
<tbody>[TR]
[TD]3000594794
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]3000600944
[/TD]
[/TR]
[TR]
[TD]3000601323
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]blank
[/TD]
[/TR]
[TR]
[TD]3000601327
[/TD]
[/TR]
</tbody>[/TABLE]
Desired Outcome
[TABLE="width: 112"]
<tbody>[TR]
[TD]3000594794
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]3000600850
[/TD]
[/TR]
[TR]
[TD]3000600944
[/TD]
[/TR]
[TR]
[TD]3000601323
[/TD]
[/TR]
[TR]
[TD]3000601323
[/TD]
[/TR]
[TR]
[TD]3000601323
[/TD]
[/TR]
[TR]
[TD]3000601323
[/TD]
[/TR]
[TR]
[TD]3000601327
[/TD]
[/TR]
[TR]
[TD]3000601330
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]