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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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
946
Peter_SSs
Peter_SSs
M
  • Solved
trying to select two columns
Replies
4
Views
349
Alex Blakenburg
A
A
  • Question
Update each bar color based on values in column A
Replies
4
Views
710
anand3dinesh
A
R
  • Solved
Formula to copy the first value in a column of cells into the first blank cell
Replies
4
Views
332
Rodders1981
R
nicolews
  • Question
Conditional Formatting based on other cell values
Replies
3
Views
819
ERINWILLIS01
E

Forum statistics

Threads
1,214,586
Messages
6,120,402
Members
448,958
Latest member
Hat4Life

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