You can't merge data without losing parts of it, you can use a help row,
insert a help row below the 2 rows you want to "merge", then use

=A1&A2

copy across as long as needed, while selected copy and paste special as
values in place, then delete the 2 original rows

Regards,

Peo Sjoblom

"willid" wrote:

I am trying to combine data from 2 rows so that i can use the data as one row
which will enable me to sort the data accordingly.