Item Changing with New Information Need Reporting Help

elongo

I have test for items a,b,c,d and a report that is pulling data from those tests. Occasionally I'll have an item that will turn to a version 2 now considered a2. Column information wont change. Now there will be an a, b, c, d, and a2 rows. What should I do to pull the correct information to my report now that a (the original) is no longer relevant for me. Should I add a column to original sheet? Should I add a function to lookup?

Paul Newcome

Are you able to provide screenshots for context?