The AddRows column is no longer required and can be deleted.

A new table is add to Excel with the required number of rows added.

Select Table and any other selections as required.

To return the results to Excel select Close & Load or select the drop down at the bottom right corner of Close & Load, and select Close & Load To ….

Power Query expands the table by inserting the specified number of rows.Alternatively, select the drop down icon in the upper-right corner of the column label and select Expand to New Rows. From the menu select Transform and from the Structure Column section select Expand. Select the Rows column and on the Home menu select Remove Columns from the Manage Columns section as the column is no longer needed.Select OK, and the new column “AddRows” is added with a List data type.is to fill in the values between 1 and the number in the specified column, which in our example is the field.

The 1 is the first value and the two dots. In the Custom Column Formula section enter the formula = is used in Power Query to create a list. In the Custom Column dialog box, enter a name for the column, e.g.To create the list, select the Add Column menu item and Custom Column under the General section. Each client will start at 1 and increment by the number specified under the Rows column. Create a new column containing a list for each client.The Power Query editor opens with a preview of the data.On the menu select Data and under the Get & Transform Data section select From Table/Range. Ensure your cursor is in a cell within the table.You can quickly determine if your version of Excel includes Power Query by clicking the Data tab, and looking for the “Get & Transform Data” group of commands. In the example below, we require additional rows for each client based on the number in the Rows column. This will be accomplished using Power Query. In this Excel tip, rows will be inserted based on the specified number in a column. Inserting multiple rows in a table can be very time consuming.

How to add multiple rows in excel sheet