thanks, i will take a look at that. i was able to brute force it in a similar fashion. I used a fixed INDEX(1,1)... INDEX(1,22) where you have the [@1]. and yes just parsing each row individually.
Risking causing a coma from boredom, each row is Purchase Order (part #, qty, initial date). There are multiple POs for each part #. The table beside the 'Text' col (Table 1) is pulling from a condensed table that only has 1 row for each part # and has the total amount product available each week. The function of Table1 is to split up the condensed data into chunks that correspond to each PO and put those chunks into the right weeks. easier to see below. Condensed table on top and Table 1 on the bottom.
The Text part of it is the result of any changes on how the POs are currently loaded. The group that makes all these changes wants the data in that format, so I was trying to automate it. I don't doubt there is a better way to ultimately input the data, but I am not digging into their SAP crap if I don't have to.