ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Merging Two Rows Into One (https://www.excelbanter.com/excel-worksheet-functions/18192-merging-two-rows-into-one.html)

Ourania

Merging Two Rows Into One
 
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?

Adam


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?



All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com