I need the text in bold to be pasted downwards until preferably numbers on the right stop. This would then need to repeat again at the next bold text in column A several times.
If its easier, The text in bold "191007-Job Name 1" can be pasted all the way to the next cell with text in it, in this case "191007-job name 1" can be pasted all the way to the cell above "191008-Job Name 2"
If its easier, The text in bold "191007-Job Name 1" can be pasted all the way to the next cell with text in it, in this case "191007-job name 1" can be pasted all the way to the cell above "191008-Job Name 2"