I have only given data A & B 2 columns and want to create column C to concatenate column A & B with autofill function. How can I rewrite the C1 formula to make it?

Any thoughts? thank you

CodePudding user response：

try:

={"PK"; ARRAYFORMULA(TEXT(B2:B, "yyyy-m-dd")&A2:A)}

or just:

={"PK"; ARRAYFORMULA(B2:B&A2:A)}