Group line item docs into a NetSuite item object (array)

I have a source table with invoice items and I’m trying to create a NetSuite invoice object, which contains a list of items. Has anyone a good way to accomplish this? I tried a group by fields but i end up getting multiple entries for the invoice level attributes also.