Let’s say I have the following values
Column 1 column 2 column 3 Article - John|Doe Article - John,Doe John, Doe
I have column 1 in my file. I created column 2 and column 3 manually by hand.
Is there a way to drag the formatting of column 2 and column 3 down to the rest of the rows so that the same idea applies even though Column 1 might have different values? I.e.
Article – John|Smith
I actually did this in Excel, but I’m not sure how I did it. All I did was copy and paste some values, but I’m not sure how I can replicate this as it happened by accident.