I'm having a bit of trouble figuring out how to do this in Excel. I have 4 columns and a large amount of rows. Like below: link1 345 link5 330 link5 327 link4 180 link3 894 link2 660 link4 174 link3 900 link2 653 link1 350 I need the rows of columns A and C to match up WHILE taking the numbers to the right of them with them as they shift. Here is an example of how I need it to look: link1 345 link1 350 link2 653 link2 660 link3 894 link3 900 link4 174 link4 180 link5 327 link5 330 I've tried asking at excel forums etc, but can't seem to get helpful answers. This is my last resort place to ask. Can this even be done? Thanks.