Making labels on Brother printer

%3CLINGO-SUB%20id%3D%22lingo-sub-3448722%22%20slang%3D%22en-US%22%3EMaking%20labels%20on%20Brother%20printer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3448722%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20want%20to%20make%20a%20layout%20for%20printing%20labels.%20The%20sheet%20has%205%20columns%20from%20A%20to%20E%2C%20where%20A%20to%20D%20are%20texts%20and%20E%20contains%20the%20number%205.%20I%20want%20all%20lines%20to%20duplicate%20with%205%2C%20with%20the%20number%201%20in%20column%20E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Blugg1971_0-1653993626750.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653993626750.png%22%20style%3D%22width%3A%20316px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653993626750.png%22%20style%3D%22width%3A%20316px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653993626750.png%22%20style%3D%22width%3A%20316px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653993626750.png%22%20style%3D%22width%3A%20316px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653993626750.png%22%20style%3D%22width%3A%20316px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653993626750.png%22%20style%3D%22width%3A%20316px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653993626750.png%22%20style%3D%22width%3A%20316px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653993626750.png%22%20style%3D%22width%3A%20316px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F376311iA81AE6646F4F1E06%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Blugg1971_0-1653993626750.png%22%20alt%3D%22Blugg1971_0-1653993626750.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3448722%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3448858%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20labels%20on%20Brother%20printer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3448858%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1408381%22%20target%3D%22_blank%22%3E%40Blugg1971%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20this%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Blugg1971_0-1653996137729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653996137729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653996137729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653996137729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653996137729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653996137729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F376317iE3A54BC2A2F2B9C7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Blugg1971_0-1653996137729.png%22%20alt%3D%22Blugg1971_0-1653996137729.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3448886%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20labels%20on%20Brother%20printer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3448886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1408381%22%20target%3D%22_blank%22%3E%40Blugg1971%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Blugg1971_0-1653996425138.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653996425138.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653996425138.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653996425138.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Blugg1971_0-1653996425138.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F376319iE614383FE4E579D3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Blugg1971_0-1653996425138.png%22%20alt%3D%22Blugg1971_0-1653996425138.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3448955%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20labels%20on%20Brother%20printer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3448955%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1408381%22%20target%3D%22_blank%22%3E%40Blugg1971%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20with%20Power%20Query%20like%20in%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3475191%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20labels%20on%20Brother%20printer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3475191%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1174419%22%20target%3D%22_blank%22%3E%40Quadruple_Pawn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBrilliant%2C%20this%20has%20to%20be%20the%20right%20way.%20But%20can%20you%20please%20help%20me%20with%20the%20steps%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

 

Blugg1971_0-1653993626750.png

 

3 Replies

@Blugg1971 

 

Like this

 

Blugg1971_0-1653996425138.png

 

@Blugg1971 

Maybe with Power Query like in the attached file.

@Quadruple_Pawn 

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