Making labels on Brother printer

[Blugg1971]

I want to make a layout for printing labels. The sheet has 5 columns from A to E, where A to D are texts and E contains the number 5. I want all lines to duplicate with 5, with the number 1 in column E

[#2]

@Blugg1971 

Like this

[#3]

@Blugg1971 

Maybe with Power Query like in the attached file.

[#4]

@OliverScheurich 

Brilliant, this has to be the right way. But can you please help me with the steps?