In this Post, we will discuss how to combine multiple rows to one in excel. There can be two methods to achieve this:
Method 1 : Multiple rows to one rows can be combined into one by using concatenate function but applying function every time can be time-consuming.
Let us see the first method use concatenate function and provide all the cells as an argument you want to combine. Here in this example , we have used =CONCATENATE(B3,B4,B5,B6,B7,B8,B9,B10)
Below is the Output:If you want to add Space in between just add “ ” as an argument in concatenate function.
Method2 : This Method uses Notepad++ First copy all the cell you want to combine from Ms Excel and paste it in Notepad++ New Tab.
After Pasting in note pad ++ it will look something like this
After Pasting in Notepad++ find \r\n and replace it with blank or space if you want gap in between the line (See Below Screen Shot) ,just copy and paste back to MS Excel .
Hope You will like it Please share this Trick With Others.