Duplicate entrey

[valentin6x6]

Hi !
Is possible in bellow ex every time i have in the B column a value (210-059 B7) in the A column to have the same value every time.
Now A9;A11;A13 should have same value like A7 and I have a loooong list also the are not only one row apart all the time. Thank you!
Capture.PNG

[pwnyadav007]

For that u hv to create a table First, then according to that u hv to use vlookup formula in A column


if u dont understand than give me sample file I'll show u how to do that

[valentin6x6]

I have attached a piece of my file for an example and some explination on wath i need to do.
Let me know if you can help.