Well, instead of pasting into the whole row, you could just select the cells you're interested in and paste into those.
But if that's too fiddly (maybe you want to add more data to the source row later on, for example), setting A2 to be "=IF(A$1<>"", A$1, "")" and then copying and pasting that into the whole row will also work.
Cheers,
Tim
|