Your table structure is not normalized. Each Product should create a unique
record in a related table.

The solution depends on the problem which I am having trouble identifying
(other than the table structure). I think you will need to first normalize
your table with a union query like:
SELECT RecordNum, Product1 as Product
FROM tblMySpreadsheet
WHERE Product1 Is Not Null
UNION ALL
SELECT RecordNum, Product2
FROM tblMySpreadsheet
WHERE Product2 Is Not Null
UNION ALL
SELECT RecordNum, Product3
FROM tblMySpreadsheet
WHERE Product3 Is Not Null
UNION ALL
SELECT RecordNum, Product4
FROM tblMySpreadsheet
WHERE Product4 Is Not Null
UNION ALL
SELECT RecordNum, Product5
FROM tblMySpreadsheet
WHERE Product5 Is Not Null
UNION ALL
SELECT RecordNum, Product6
FROM tblMySpreadsheet
WHERE Product6 Is Not Null
UNION ALL
SELECT RecordNum, Product7
FROM tblMySpreadsheet
WHERE Product7 Is Not Null;

Use the union query in the Record Source of your report.