If you look at the sample data in @Table, AttrVal1 column has a single word entry for all rows while the second column has multiple words for every row.

I have also used a string splitter function dbo.DelimitedSplit8k, created by our very own Jeff Moden, which , you can find here[/url]

Let us know if you need any help.