Expand a condensed grouped list

This isn’t an Epicor question, but there are some samrt people here that deal with lists of data all day long …

I’ve got data in Excel files like the following:

I need to expand this data so that I get an individual row for each item in the designator column. Such that my final data would be:

Preferably all in Excel. I would copy the table from the source doc, paste it into my “converter” spreadsheet, and another section of the spreadsheet would be populated with the expanded list.

If you know how to do it in SQL, I’d like to see how, and maybe I could do something similar in Excel

I don’t need the expanded list to be sorted (I can do that later).

Some background … These are BOM’s for PCB’s manufactured outside of our company. It’s common to group the parts by Mfg’r and Mfg’r P/N, listing all the designators that this combination of Mfg & P/N apply to.

We need to update some PCB CAD files which has a paramater manger, which I can paste a table (clipboard data in rows and columns) into. Basically to populate the outlined section of the following:

image

Thoughts?

The only way I can think of is with a Macro…

vba - Excel macro -Split comma separated entries to new rows - Stack Overflow

1 Like