If I have to merge data from multiple rows from one excel file and copy it to the another excel file in one row using comma and I want only one cell to merge and other cells from that row items to be the same as they are. How can I do this?

Question

If I have to merge data from multiple rows from one excel file and copy it to the another excel file in one row using comma and I want only one cell to merge and other cells from that row items to be the same as they are. How can I do this?

Answer 1

Hi User, 

Thank you for reaching out to Microsoft Q & A forum.   

Step-by-Step Guide to Merging Data in Excel 

1.Open the Source Excel File: 

Identify the column that contains the data you wish to merge (e.g., column B). 

2.Utilize the TEXTJOIN Function: 

In a new cell (e.g., D1), input the following formula: 

=TEXTJOIN(",", TRUE, B2:B10)

This formula will concatenate the values from cells B2 to B10, separated by commas. 

3.Copy the Merged Data: 

Select the cell with the TEXTJOIN formula (D1). 

Press Ctrl+C to copy the merged data. 

4.Open the Destination Excel File: 

Select the cell in the destination file where you wish to paste the merged data. 

Press Ctrl+V to paste the data. 

5.Copy Additional Cells: 

In the source file, select the additional cells you wish to copy (e.g., columns A and C). 

Press Ctrl+C to copy these cells. 

Switch to the destination file, select the corresponding cells, and press Ctrl+V to paste the data. 

By following these steps, you will successfully merge data from one column into a single cell and transfer it along with other necessary cells to a new Excel file.  

Please feel free to contact us if you have any additional questions.     

If you have found the answer provided to be helpful, please click on the "Accept answer/Upvote" button so that it is useful for other members in the Microsoft Q&A community.        

Thank you.