I have a single field (extracted from a pdf order) which alternates item numbers and quantities like this:
What is the easiest way to reformat and reimport the data so I can bring it into two fields, one named ItemNumber and the other named Quantity? I’ve tried to manipulate it with arraybuild but not succeeding.
When done it should look like this:
Item Number Quantity
and so on.