In the Advanced Combine Rows dialog box, you need to configure as follows. Select the entire table ( A1:B13 in this case), go to select Kutools > Merge & Split > Advanced Combine Rows to enable this feature.Ģ. Now follow the instructions at the top of that screen. Ensure that the drop down menu in the left hand side.
A 'Duplicate Values' dialog box will pop up. Within this menu: Select the H ighlight Cells Rules option and from the secondary menu that appears, select the D uplicate Values. Let's see how to handle this task with the Advanced Combine Rows feature.ġ. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Select the Excel Conditional Formatting drop-down menu from the Home tab at the top of your Excel workbook. Our goal is to merge the purchases of the same customer into one row, separate by commas. Select the data range that you want to use, and then click Kutools > Merge & Split > Advanced Combine Rows to enable the Advanced Combine Rows dialog box. You can see in the table that the same customer made multiple purchases. See screenshot:Īs shown in the screenshot below, this is a sales table containing customers and their corresponding orders in different columns. With this feature, you can easily achieve:Ĭombine rows with same values and merge the values of other columnsĬombine duplicate rows and sum/average the values of other columnsĬombine duplicate rows and keep the first or last data of other columnsĬlick Kutools > Merge & Split > Advanced Combine Rows to enable this feature. The Advanced Combine Rows feature of Kutools for Excel can help you solve this problem. Suppose you are working with a data set that contains duplicate records in a column, and now you need to combine rows based on the same values in that column and perform some operations (such as merging, calculating) on the cells in the same row of other columns.
0 kommentar(er)
