Creating table based on another table content

Hi guys,

I was not able to describe my problem properly in Title part even in my native language. So I will describe it in more details now. I wish to kindly ask you for your help in this:

In Excel 2016, I wish to have List 1 with 2 columns (Name, Count). In Name, I would have things like Ruler, Pencil, etc. Column would be Null.

On List 2, there would be empty table.

After writing a number into column Count on List 1, the rows should be automatically created in table on List 2.

Example:

List 1

Name Count
Pencil 3

==>

List 2

Pencil 1
Pencil 2
Pencil 3

The application is on other items, which makes sense (not like Pencil, that is only as example).

Any suggestions, please?

Thank you very much for your time, very appreciate it!

Best regards,

A.