| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
| Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Hybrid Mode
