Using Column with Blanks for Primary Key (Access & Excel)

Long story shorter, I have an Excel sheet that I'm trying to incorporate into Access. The issue is, that my current Excels sheet contains blanks in the A column. That same A column would also be the primary key for the Access Table import, which it doesn't like/work. So, what's the best way of going about this? I thought of making a second Excel sheet, which references the first, except the referenced A column contains a formula which refers to the original sheet. I cannot remove blanks either in VBA or some other method because of these formulas.

A good note is this Excel sheet is constantly updated, so I have code in VBA to systematically update the Table in Access with the new information from the Excel sheet, it's just Im not sure how to solve this trivial question without tampering/ruining the original excel sheet.