I have a comma delimited field that follows this syntax: ID, Name, ID, Name. Yes, I have lambasted the person who thought about creating a field like this. But, I can't get to the original data, so I have to break it out to 1 per row where ID and Name are separate fields, but correctly aligned. The vendor field can have any number of "Vendors" in it
Data:
| PO_ID | Vendor |
| 2222 | AAA, Amazon, BBB, Best Buy, CCC, CoconutWater, DDD, Doritos |
| 5555 | AAA, Amazon, BBB, Best Buy, FFF, Ferrari |
Results needed
| PO_ID | VendorID | VendorName |
| 2222 | AAA | Amazon |
| 2222 | BBB | Best Buy |
| 2222 | CCC | CoconutWater |
| 2222 | DDD | Doritos |
| 5555 | AAA | Amazon |
| 5555 | BBB | Best Buy |
| 5555 | FFF | Ferrari |
I've been toying with various transposes, crosstabs, samples, and others but just can't quote get it.
Thanks for any help!!!
