Filling Blank Rows w/ Values

**XtremeSki2001** · 10-13-2009, 08:24 AM

Hi All! Great forum you have here and the resources available here via search are great. I haven't found what I'm looking for - so I'm hoping you all can assist with something I think is quite simple .. but I keep hitting a wall.

I have a situation in Excel that currently looks like this:

Column A
a
<blank>
<blank>
b
<blank>
<blank>
<blank>
<blank>
c
<blank>
<blank>
<blank>
<blank>
<blank>
<blank>
d
(^^ each line represents a row ^^)

This goes on for several thousand lines - sometimes there are no blanks, sometimes 1 and sometimes 30 or more.

What I'd like to do is find a formula I can use on the column to the left (or right) of the data above to create a consistent list without blanks as seen here:

Column A
a
a
a
b
b
b
b
b
c
c
c
c
c
c
c
d
(^^ each line represents a row ^^)

Essentially, I want to fill in the blanks after each value with the value from above - when I reach a new value I want to fill in the blanks after the new value with the data from the new value.

I hope I've explained this well enough. Thank you in advance for your help!

-E

**NBVC** · 10-13-2009, 08:35 AM

Select column A and then hold the CTRL key and select A1.

Then go to Edit|Go To and click Special....select Blanks and click Ok.

enter an = sign and hit the up arrow key.

Hold the CTRL key again and hit ENTER.

You may have to fix whatever was in A1.

**XtremeSki2001** · 10-13-2009, 09:19 AM

Originally Posted by NBVC

Select column A and then hold the CTRL key and select A1.

Then go to Edit|Go To and click Special....select Blanks and click Ok.

enter an = sign and hit the up arrow key.

Hold the CTRL key again and hit ENTER.

You may have to fix whatever was in A1.

Awesome! You da man. Thank you.

**NBVC** · 10-13-2009, 09:24 AM

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**Parham** · 06-12-2016, 10:22 PM

Hi,
I want to insert a list of values from column (A) to just blank cells of column (B), respectively. because of so many row and cells, filling blank cells is so difficult, manually. please help me.
Here is a short example of data:
Untitled.png
Thanks

**Parham** · 06-12-2016, 10:14 PM

Hi,
I want to insert a list of values from column (A) to just blank cells of column (B), respectively. because of so many row and cells, filling blank cells is so difficult, manually. please help me.
Here is a short example of data:
Untitled.png

Thanks,

**FDibbins** · 06-13-2016, 12:00 AM

Parham welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**Parham** · 06-13-2016, 07:05 AM

[VBA]
Hi,
I'm having difficulty in creating a VBA code that will make, insert a list of values from column (A) to just blank cells of column (B), respectively. Because of so many row and cells, filling blank cells is so difficult, manually. Please help me.
Thanks in advance
Here is a sample of data:
sample.png
[/VBA]

**FDibbins** · 06-14-2016, 12:16 AM

Parham welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.