Generate new lines with the existing value except for 1 column to generate specific values

XXX_Rosy_XXX

I need help to get started based on dummy data below

when specific name is spot. I will need to create a new few lines on the facility code with the rest of the columns with same value. Please see below image

Facility Code	Facility Code
01-01-HALL	01-01-0001
	01-01-0002
	01-01-0003
	01-01-0004
03-01-HALL	03-01-001A
	03-01-001B
	03-01-001C
02-02-HALL	02-02-000A
	02-02-000B
	02-02-000C
	02-02-000D
	02-02-000E

AncientPandaman

@XXX_Rosy_XXX 
just join tool will do. but you need to adjust the vlookup table (as screenshot below, suggest to remove blank row because it may impact the result).

Join Tool will generate duplicate if there have more matched record. 

RMS Data Dummy Report.yxmd