how to add multiple rows in excel formula

It may be easiest to copy the entire sheet, Is there an easier way to do this?Ĭopy the header row(s), the column widths, and the formats, The only way I can think of doing this, which would be time consuming, would be to copy the item number into multiple rows and in the column that has the distribution code I would change code for the item that is available in each distribution center.

Where cells A3:R3, A4:R4, and A5:R5, contain the same information. The result should look like: | A | B |*| S | I need to have a single distribution center column, with a single distribution code per row, and then duplicate the rows as needed for items that currently contain multiple codes. My actual sheet has 18 distribution centers, spanning columns S through AJ I reduced that to get the example to fit into Stack Exchange’s window. So the current sheet looks like: | A | B |*| S-AJ |ġ | ID # | Description |…| Distribution Centers |Ģ | 17 | Ginkgo Biloba |…| | | | | | | SE |ģ | 42 | Ginseng |…| | MP | MS | | NW | | |Ĭolumns C through R contain other attributes of the items, such as UPC code, cost, and price, which are not relevant to this question. An item with multiple distribution centers will have multiple distribution center codes (in their respective columns). A cell in the row for item X and the column for distribution center Y is marked with the code for distribution center Y if item X is available there and blank otherwise. There is currently one row per item, with one column for each distribution center. I have multiple items that are available in multiple distribution centers (i.e., a many-to-many relationship).

How to add multiple rows in excel formula