Search code examples
google-sheetsconcatenationgoogle-sheets-formulastring-formattingtextjoin

How can I rewrite the Google Sheet formula to make it autofill without hand dragging?

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? enter image description here

Any thoughts? thank you

Solution

  • try:

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

    or just:

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