从另一列随机文本字符串中的一列中重复特定文本x次

I have some Text Values in sheet 1, A4:A400 and for each value in Column A there are 10 codes in non-consecutive cells in Row 1. I want a formula in "sheet 2" to put each text value 10 times in column A with the code in column B and then repeat the same with a new text value with the same 10 cods. LIke:I have some Text Values in sheet 1, A4:A400 and