Macro or Formula to create new rows where there is multiple values attached to it

Okay so my title is very hard to explain it so shortly so hopefully this will make sense...

Basically i will have a sheet with Column A being a unique value (my example is a fruit)
Column B will include all the values that relate to the unique value and they are ALWAYS separated by a space.

I need to make multiple rows of the unique value (the fruit) and have each row for that fruit display just one of the values relating to it. So in my example, Banana relates to "8" "7" "6" and "5" so instead of one row that says "banana - 8 7 6 5" I need 4 rows
Banana - 8
Banana - 7
Banana - 6
Banana - 5

Hopefully that makes sense :P

Attached is my example spreadsheet - Sheet 1 being the data i start with and sheet 2 being what i want the result to be. I absolutely cannot do this manually as my real data can be hundreds of rows with hundreds of values attached to each so it takes hours upon hours to do manually

Thank you

Example Sheet.xlsx

Awesome!! thank you, that's perfect. Just tried it on some of my actual data (1350 lines lol) and it worked wonderfully.

For a formula solution.

Row\Col	A	B	C	D	E	F	G	H	I
1	Apple	1 2 3 4 5 6 7 8		Apple	Banana	Orange	Grape	Helper row	D1:G1{=TRANSPOSE($A$1:$A$4)}
2	Banana	8 7 6 5		1 2 3 4 5 6 7 8	8 7 6 5	8 9 6 5 2 4	1 6 8 7 4 2 6 9	Helper row	D2:G2{=TRANSPOSE($B$1:$B$4)}
3	Orange	8 9 6 5 2 4		Apple - 1	Banana - 8	Orange - 8	Grape - 1
4	Grape	1 6 8 7 4 2 6 9		Apple - 2	Banana - 7	Orange - 9	Grape - 6
5				Apple - 3	Banana - 6	Orange - 6	Grape - 8
6				Apple - 4	Banana - 5	Orange - 5	Grape - 7
7				Apple - 5		Orange - 2	Grape - 4
8				Apple - 6		Orange - 4	Grape - 2
9				Apple - 7			Grape - 6
10				Apple - 8			Grape - 9

D1:G1 committed all at once by pressing and holding Ctrl and Shift while hitting enter this formula.

Formula:

Please Login or Register  to view this content.

and in D2:G2 this array formula committed the same way.

Formula:

Please Login or Register  to view this content.

These are helper rows.

Then in D3 array enter also this formula.

Formula:

Please Login or Register  to view this content.

fill down and across until you get blanks.

File attached.