Hi All,

First post. Please help me figure out how to reorganize data I have in a spread sheet. I have a bill of materials that needs to be imported into an ERP system. However, the data is not organized in a readable manner.

What we have is:

Item code, component 1, QTY, Cost, component 2, QTY, cost, component 3, QTY, Cost etc....

what is required is

Item Code, component 1, qty, cost
Item Code, component 2, qty, cost
Item Code, component 3, qty, cost
etc...


Is there a way to write a script to re-organize the data?

Many Thanks!
Dan