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.
0 Comments
Leave a Reply. |