Move data from 1 column to another

[helpmethanks<3]

explanation.PNG

Here you will find a image of what im trying to do. I tried using VBA but didnt succeed. Hope anyone can help me find a solution that will make it go faster dont want to manually place the information.
(FYI: i placed the information in Column A manually aswell. i have a list of categories that need to be linked to products but the products are multiple while the categories are single)
So in short i need to somehow make it so that the information in column B that has more rows than column A to be connected to eachother. idk if im explaining it correctly but the what im trying to say is:
in column B i have 8 rows of the same name and those 8 rows have the same category. In column A i only have that category once and now i need to paste the category 8 times for example this is different for every unqique name in column B.
Hope that clears it out a bit xd.

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[helpmethanks<3]

yeah i saw but i thought the image would be enough info but ill add it now

[JeteMc]

If I understand the statements in A30:A31 of the file correctly then the following should do what you want.
Paste the following into cell B1 and then double click the fill handle to copy down: =INDEX(A$1:A$6,C1)
Let us know if you have any questions.