I know there are a lot questions about MANY TO MANY relationship, but none seemes to work for me, because it is more of a question about concept rather than a code. So I need some clarification on how to implement my idea.

I am trying to make LEGO database. I have SETS which has many MINIFIGURES. Also MINIFIGURES appear in many SETS. I was doing it like this, in Excel(csv) file. And it was  **SETS** "table". 


    ID	SET_NAME                         SET_ID	  MINIFIGURES_LIST
    1	Spider-Man's Doc Ock Ambush	     6873	  Doc Ock, Spider-Man, Iron Fist
    2	Spider-Man: Spider-Cycle Chase   76004	  Spider-Man, Venom, Nick Fury
    3	Electro	                         5002125  Electro
    .....

First step of databse implementation was to **SETS** table.

    CREATE TABLE Sets (
    ID int NOT NULL AUTO_INCREMENT,
    SET_NAME varchar(255),
    SET_ID varchar(255),
    );

And then insert data:

    Insert into Sets (SET_NAME, SET_ID)
    VALUES ('Spidermans Doc Ock Ambush' , '6837'), 
    ('Spider-Man: Spider-Cycle Chase' , '76004')
    ('Electro', '5002125')
    ;
    ...
Next step was to create **MINIFIGS** table, and give them attributes.

    MIN_ID	MINIFIG_NAME	MINIFIG_ID
    1	    Doc Ock	        SH040
    2	    Spider-Man	    SH038
    3	    Venom	        SH055
    4	    Nick Fury	    SH056
    5	    Iron Fist	    SH041
    6	    Electro	        SH141

Like this:

    CREATE TABLE MINIFIGS (
    ID int NOT NULL AUTO_INCREMENT,
    MINIFIG_NAME varchar(255),
    MINIFIG_ID varchar(255),
    );

And then insert data:

    Insert into Minifigs (MINIFIG_NAME, MINIFIG_ID)
    VALUES ('Doc Ock' , 'SH040'), 
    ('Spider-Man', 'SH038')
    ('Venom', 'SH055')
    ;
    ...

How to proceed from here? Am I missing a step? Where and how I should do it? Where is a step to relate tables? Do I have to do it like this, first split Minifigures_Sets cell, and create table from this, or? If I create table like this, there will be duplicates. Where is a step to create junction table? 

    ID	SET_NAME                        SET_ID	MINIFIG_NAME   MINIFIG_ID
    1	Spider-Man's Doc Ock Ambush	    6873    Doc Ock	       SH040
    2	Spider-Man's Doc Ock Ambush	    6873    Spider-Man	   SH038
    3	Spider-Man's Doc Ock Ambush	    6873    Iron Fist	   SH041
    4	Spider-Man: Spider-Cycle Chase	76004	Spider-Man	   SH038
    5	Spider-Man: Spider-Cycle Chase	76004	Venom	       SH055
    6	Spider-Man: Spider-Cycle Chase	76004	Nick Fury	   SH056
    7	Electro	                        5002125	Electro	       SH141

And then, where and how i do insert new data? Into Junction table? Can main tables pull data from junction table?

     ID	SET_NAME                         SET_ID	  MINIFIGURES_LIST
     99 Web Warriors Bridge Battle       76057	  Aunt May, Spider-Woman, Spider-Man, Kraven, Green Goblin, Scorpion, Scarlet Spider

Thank you.