What data do you want put on the same row?
Is there data in other columns besides F and N? If so, what happens to that data when the values in F and N are lined up?
Perhap you should post some example data of your "before" and "after" so we can see what you are requesting.
Please click on the following line and read the instructions on how to post data in this forum.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.