![]() ![]() ![]() For example you want to combine rows by the same name, you must move the name column to the first column of the specified range. Note : This VBA can only combine rows by the values in the first column. Now you will see the rows in the specified range are combined with commas by the same ID. Combine multiple rows of excel data into one row In the popping out Kutools for Excel dialog box, please select the rows you will combine, and click the OK button. This method will introduce a VBA to quickly combine all rows with the same ID or name in the specified selection. ![]() For example, you have a table as below screenshot shown, and you need to combine rows with the order IDs, any ideas? Here, this article will introduce two solutions for you. ![]()
0 Comments
Leave a Reply. |