I'm not sure if Excel can do this, but here is hoping! I have data that looks like this:A column