Decompose the table into smaller tables that satisfy the normal forms.
Make sure that your new tables have all of the same data as the original tables,
Download the attached Excel spreadsheet. It has two different normalization problems, one in each tab. You can switch between problems by clicking the names “Problem 1” and “Problem 2” in the bottom left corner.