I'm a bit embarrassed to post this question but I'm sure there is a fairly straight forward solution to this problem. I'd like a formula solution, but if that's not possible, I can live with a VBA script.
I'm working with columns A and B, with data populated in B1 and downward. I'd like to...