I hav two sheets that I am going to want to cross-reference (hopefully by using an SQL chart)...
Sheet 1: Already, I have a sheet that I built with User ID #s and some resulting scores data.
Sheet 2: I have a .csv coming from an outside provider that will have matching User ID #s in a column, but the data categories are different.
I watched the video on how I can use the SQL interface to make a display sheet, but I want to cross-reference the two sheets I mentioned above (Sheet 1 & 2) so that I can view all datasets by ID number... Essentially, I want to combine the sheets without having to manually match the ID numbers, add new columns and data-enter each of the new data categories that are being sent in from Sheet 2.
Where do I start? Help is much appreciated. Love the product; need to learn the 'languages'.