How to normalise a merged table

See: Normalised Schema

Splitting out tables.

Resource: Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)