How to normalize this table up to third normal form (3NF)?

How to properly normalize this table?

(third row with two blanks are still the data of Allen which has the subscriber number of 110) (same goes with 5th and 6th row two blanks, data is still from its preceding term Smith which has the subscriber number 202) (they were just left blank to identify them as the values from their preceding terms)

My process of normalizing:

First Normal Form (1NF):

Second Normal Form (2NF):

Third Normal Form (3NF):

I used this site for reference:
https://www.sqa.org.uk/e-learning/MDBS01CD/page_27.htm

I suspect a spreadsheet is not the best way to normalize data.

The first thing you do is determine the entities or objects that make up your database.

In your example, I see Subscriber, Magazine, and Subscription as entities.

The next thing you do is determine the relationship between the entities.

• A Subscriber can subscribe to one or more Magazines.
• A Magazine runs for a Subscription period.
• A Subscription is a relationship between a Subscriber and a Magazine.

I'm going to leave the rest to you. There are plenty of resources available that show you how to normalize data, including this Wikipedia article.