Making labels on Brother printer

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...