Add rows based on criteria in parent row

[neov]

Hi all - I've got a spreadsheet for manufactured items and a bill of material.

Column A is the parent item - can be same item on many rows, but there are multiple values in this column

Column B is the component - each parent will typically have 7-20 components - give or take a few

Columns C through DE - are the designators for each parent/component combination. Some will only have one, two, or maybe even 3 - but there are some that have as many as
107 different designators listed in columns C - DE.

What I need is to change the layout so that columns A and B are still parent and component, respectively, but I need each row to be a unique parent/component/designator combination - no items should be in columns D and beyond.

This will drastically increase the number of rows in my table, but it will allow me to perform a simple copy/paste to update my SQL table that I need to store this data in.

Thanks in advance.

 

[jbeaucaire]

'ROWS TO COLUMNS
Here's a macro for expanding rows of data to multiple rows parsing out the values in the row while duplicating the header row as categories. There's a sample workbook too you could drop your data into and test it out.

Rows to Columns - Part 1a​

When you run the macro, indicate column C as the column to start splitting by, then A:B will be duplicated on all the new rows as you've described.

 

[neov]

Jerry - hot stuff, worked like a champ! Thank you.