Is there an easy way to quickly fill blanks in a column with values based on what is before or after each cell? (please see details)

D

doge_3

Board Regular
Joined
Apr 11, 2014
Messages
72
Hello,

I have 2 colums that loook like this:
1001
Billing
Shipping
1003
Shipping
1005
Billing

<tbody>
</tbody>

I want it to look like this:
1001
Billing
1001
Shipping
1003
1003
Shipping
1003
1005
Billing
1005

<tbody>
</tbody>


Basically, I want to fill the cells in the first column with values until the next value. If that makes sense.

How can I do this? Please help!
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
Select the first column, press f5, then the 'Special...' button, choose Blanks from the options and press OK.
Now type = then press the up arrow followed by Ctrl+Enter.
Finally you can copy the column and paste special - Values to convert the formulas to values.
 
Upvote 0
You must log in or register to reply here.

Similar threads

O
  • Solved
delete 8000 rows based on what I write items in helper column
2 3 4
Replies
33
Views
957
Peter_SSs
Peter_SSs
M
  • Solved
trying to select two columns
Replies
4
Views
351
Alex Blakenburg
A
A
  • Question
Update each bar color based on values in column A
Replies
4
Views
736
anand3dinesh
A
R
  • Solved
Formula to copy the first value in a column of cells into the first blank cell
Replies
4
Views
346
Rodders1981
R
nicolews
  • Question
Conditional Formatting based on other cell values
Replies
3
Views
822
ERINWILLIS01
E

Forum statistics

Threads
1,214,923
Messages
6,122,283
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top