Click Kutools > Insert > Duplicate Rows / Columns based on cell value to enable the utility. This utility also can help to duplicate each column a number of times based on the numeric values in a specific row.ġ. Then the rows are duplicated as the below screenshot shown. Note: You can click the Example section to expand the dialog for more example details of the steps.
Select the column range that you want to duplicate rows based on in the Repeat Times box.Select the range you will duplicate the rows in the Insert Range box.Select the Copy and insert rows option in the Type section.In the Copy and insert rows & columns dialog, you need to:
Click Kutools > Insert > Duplicate Rows / Columns based on cell value. Supposing you have a range of data as the below screenshot shown, now, to duplicate each row a number of times based on the numeric values in column F, please do as follows.ġ. But with the Duplicate Rows / Columns based on cell value utility of Kutools for Excel, you can quickly get it done with only several clicks.ĭuplicate rows based on cell value in columnĭuplicate columns based on cell value in rowĭuplicate rows or columns by typing repeat timesĬlick Kutools > Insert > Duplicate Rows / Columns based on cell value to enable the utility.
Normally, may be there is no good and quick way for you to duplicate each row or column of a specific range n times except the VBA code in Excel.
0 kommentar(er)
