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