Append/Import data to normalized tables

[margzj]

I already searched online but I can't seem to understand the steps.
can anyone help me.

here is my table

[June7]

Append/Import data from where? Provide example of source data.

[margzj]

Append/Import data from where? Provide example of source data.

oops sorry, from excel

[June7]

The Excel is one big flat file spreadsheet and you need to import to normalized related tables? Is this a one-time event? Review https://support.office.com/en-us/art...F-4106F78850B4

Then tell us what you tried and issues you encountered.