Hey all. I'm trying to import kits/assemblies, but the data I have has the assembly repeating lines for each component. Does anyone possible have a macro that can take a file from this type of format and put it in the netsuite format with member1, member2, etc. as columns across the top? I know i've done it before, just can't find it...hoping someone out there has something. Thanks in advance!

import it as 2 files. Then the lines need to have a value that ties it back to the assembly item. With this format you can have each member item on a unique row instead of across the columns.

gotcha, thanks! Although I did this as an excel macro a long time ago. Ended up useful for a few clients, so good news there.