How To re-organize data

**Daniel.S** · 03-08-2012, 06:30 PM

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

**rylo** · 03-08-2012, 06:44 PM

Dan

Is your data in a single cell, or is it spread across the row?

rylo

**tigeravatar** · 03-08-2012, 06:50 PM

Dan,

rylo asked a good question, one I didn't think about. I assumed the data was spread across the row, with each comma denoting a new cell. I finished a script and so figured I would post it in case that assumption was correct (Ignore this post if it wasn't).

Change the StartRow to the first row containing data. I set it to 2 assuming row 1 was headers and the data started in row 2.

Please Login or Register  to view this content.

**Daniel.S** · 03-08-2012, 07:04 PM

Thanks!! that is absolutely fantastic.

I have another small request. is it possible to skip blanks on the component level, and to add line numbers in for each component? Line number series should be 1000,2000,3000

Thanks again!!!!!