Ahhh, ok - it looks pretty complicated then. It would take lot of IF statements along with loops in vba to code that up - and given that we have only seen a few examples from a dataset of 125k this is likely to continue to expand a fair bit.
You may be able to use the code I provided above and step through the process several times splitting out a condition at a time and then amending the code for the next field, however, you would need a definite list of possible fields that would come up to ensure you don't lose any data.
I pretty much been cleaning the data up and it's 25k rows to a comma delimited file... How can I pull each field then it's value i.e., City is Frederiction, Price Group1 is 20, Price Group2 is 23 extra...I can then UNION into a PRICE_GROUP...See where I going with this and then it's doable prayerfully...lol
[TABLE="width: 1790"]
<tbody>[TR]
[TD] Sold to party , 100091461 , Price Group , 20,23 , City , BOAZ , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR[/TD]
[/TR]
[TR]
[TD] Price Group , 25 , City , FREDERICTON , Shipping condition , PU , Shipping Plant , 1323 , Price Group , 19,22,25,27,29[/TD]
[/TR]
[TR]
[TD] Sold to party , 100092818 , Price Group , 20,23 , City , LEOLA , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR[/TD]
[/TR]
[TR]
[TD] Sold to party , 100092818 , Price Group , 20,23 , City , LEOLA , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR[/TD]
[/TR]
[TR]
[TD] Sold to party , 100091460 , Price Group , 20,23 , City , CALDWELL , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR[/TD]
[/TR]
[TR]
[TD] Sold to party , 100091460 , Price Group , 20,23 , City , CALDWELL , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR[/TD]
[/TR]
[TR]
[TD] Sold to party , 100091453 , Price Group , 20,23 , City , HACKLEBURG , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Plant , RECOMMEND , Shipping condition , TR[/TD]
[/TR]
[TR]
[TD] Sold to party , 100091422 , Price Group , 20,23 , City , DOUBLE SPRINGS , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Shipping condition , PU , Plant , RECOMMEND[/TD]
[/TR]
[TR]
[TD] Sold to party , 100091422 , Price Group , 20,23 , City , DOUBLE SPRINGS , Product , BANTAM_BEAM , Size for Quality Certificate , 8 X 6.5# / 200 X 9.7 , Shipping condition , PU , Plant , RECOMMEND[/TD]
[/TR]
[TR]
[TD] Sold to party , 100092155 , Plant , RECOMMEND , Pricing Shape , 106.HPILE.SHAPE_H.HOTROLL.STRAIGHT , Deal Code , D3450 , Shipping condition , PU,RR,MM[/TD]
[/TR]
[TR]
[TD] Sold to party , 100051227 , (Pricing Shape Begins With 106 , Product , ANGLE,CHANNEL,CHANNEL_MISC) , Deal Code , TWO , Price Group , 19,22,25,27,29[/TD]
[/TR]
[TR]
[TD] Shape Size Load Quantity , 1 , Region , QCCA , Shipping Plant , 1301,1302 , Sold to party , 100060551 , Price Group , 19,22,25,27,29[/TD]
[/TR]
[TR]
[TD] Shape Size Load Quantity , 1 , Region , ONCA , Shipping Plant , 1301,1302 , Sold to party , 100061219,100061285,100060599 , Price Group , 19,22,25,27,29[/TD]
[/TR]
[TR]
[TD] Shape Size Load Quantity , 1 , Region , ONCA , Shipping Plant , 1301,1302 , Sold to party , 100061219,100060599,100061285 , Price Group , 19,22,25,27,29[/TD]
[/TR]
[TR]
[TD] Shape Size Load Quantity , 1 , Shipping Plant , 1301,1302 , Sold to party , 100092168 , Price Group , 19,22,25,27,29[/TD]
[/TR]
[TR]
[TD] Shape Size Load Quantity , 1 , Shipping Plant , 1301,1302 , Sold to party , 100092174,100092473,100092474,100092475 , Price Group , 19,22,25,27,29[/TD]
[/TR]
[TR]
[TD] Shape Size Load Quantity , 1 , Shipping Plant , 1301,1302 , Sold to party , 100092135 , Price Group , 19,22,25,27,29[/TD]
[/TR]
[TR]
[TD] Sold to party , 100092236 , Pricing Shape , 205.BAR.ROUND.HOTROLL.STRAIGHT , Steel Grade , 8630RA2,8630F , Price Group , 20 , Plant , RECOMMEND[/TD]
[/TR]
[TR]
[TD] Sold to party , 100093099 , Pricing Shape , 205.BAR.ROUND.HOTROLL.STRAIGHT , Steel Grade , 1045RAF , Price Group , 20 , Plant , RECOMMEND[/TD]
[/TR]
[TR]
[TD] Sold to party , 100093099 , Pricing Shape , 205.BAR.ROUND.HOTROLL.STRAIGHT , Steel Grade , 1080F , Price Group , 20 , Plant , RECOMMEND[/TD]
[/TR]
[TR]
[TD] Sold to party , 100093099 , Pricing Shape , 205.BAR.ROUND.HOTROLL.STRAIGHT , Steel Grade , 8620HA , Price Group , 20 , Plant , RECOMMEND[/TD]
[/TR]
</tbody>[/TABLE]
