I'm so so sorry folks, I have been a bit messy explaining myself. I thought I had it sorted out, but in the end, I don't. So once again from the top.
The excel example (attached) is the kind of data I need to re-create in Access (v2016) - I'm using created fresh database from Northwind (v2016)...