When there are multiple order items on a single Amazon order, the Seller central Zap separates unique values by comma rather than  separating by row. I’m looking for the best way of pulling this data in to our system. Are there any of the zap tools or other data manipulation tools I could use through zapier to grab each part of the data and send it over as a new row, or any ideas about handling this scenario? 

Here’s an example of the data when the zap is ready to move onto the next step: 

table:    tablename
Amount:    500.00,500.00
item:    PartNumber1,PartNumber2
StateOrRegion:    CA
PostalCode:    90210-9999
OrderStatus:    Unshipped
OrderItemId:    99999999999991,99999999999992
NumberOfItemsUnshipped:    2
MarketplaceId:    XXXXXXXXXXXX
LatestShipDate:    2023-05-12T06:59:59Z
IsSoldByAP:    False
IsReplacementOrder:    false
IsPrime:    False
IsPremiumOrder:    False
EarliestShipDate:    2023-05-04T07:00:00Z
CurrencyCode:    USD,USD
CountryCode:    US
City:    CITY
AmazonOrderId:    111-9999999-999999
TaxAmount:    0.00,0.00
OrderTotal:    1000.00
OrderItemQty:    1,1
Description:    Item Description 1,Item Description 2

Ideally, we’d have each OrderItemId as the primary key of its own row. I can handle this with SQL potentially but it would be preferable to not have to keep a table to allow for potentially 10 or more items without truncating data and failing the export