the concatenate formula might help you. It merges information in cells, i.e.
=concatenate(cell1,cell2,....celln), if you need a space between the imputs
simply add =concatenate(cell1," ",cell2,etc.)

"Ourania" skrev:

I have two rows each with about 5 columns worth of information. Is there a
function to merge these two rows of information into one?