May 31 2022 03:43 AM
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
May 31 2022 04:48 AM
Maybe with Power Query like in the attached file.
Jun 06 2022 11:39 PM
Brilliant, this has to be the right way. But can you please help me with the steps?