Wow it worked. You are a miracle worker. I am going to keep at this site. Good info. I copied and pasted it exactly into a...

Wow it worked...although I know an initial process would have to be set up first to build the "Tally" table and populate it with all the repeating groups. Now...

Ok tried that...didn't work. you can't flip the repeating group fields in to one field...unless I am missing something. Here is the table data with the repeating groups....

Boy I am with you on that one. I have been researching for several hours all over the internet and I can't find a sql plan that works. ...

I created a table in Access (don't have access to SQL server today) with the repeating fields of colors, then ran sql in my ETL tool and I got this...

Thanks for your info...but if I have the data in a table, (which would be the initial process,) would I only have to use the following part of the statement:

SELECT...

I have never heard of or used a UNPIVOT function. Can you please detail how it is used in a SQL statement.

Thanks

Mare