I am trying to merge two row's into one row. I can merge two cells into one
but when i go to auto fill the row it fill's it with the result of the first
merge. for example: ROW A First Name ROW B Last Name ROW C first name last
name
John DOE
John DOE
Jane DOE
John DOE
I have used paste special value and still get the same result