I really don't know enough to decide if View is better than table but we have performance problems so I was thinking that I would create the table and then...

I'm a little confused with your example.  I understand TestData A is a table that I create (I did that).  Is Testdata B a different table or the view that...

All of the data is already in a table. Can I build another table from the original table to pull the fields with the union statement the way you...