I don't open excel spreadsheets from the web.

Sorry, I wasn't specific enough in my request. I (and others that might help you) need CREATE TABLE scripts (temporary tables please, not permanent ones) and INSERT ... scripts that we can run directly on SQL Server to use to build a query that can help solve your problem. We need your expected outputs from the given inputs so we can really understand what you mean/need.