Forum Discussion

Leovaly's avatar
Leovaly
Copper Contributor
Aug 27, 2020
Solved

Is there a function to agregate 2 columns keeping datas from both?

Hi everybody 🙂 I saw there's a function that allows to split 1 column into 2, separating the datas you want to be parted. Is there the opposite function ? Meaning : I want to agregate (without an...
  • HansVogelaar's avatar
    Aug 27, 2020

    Leovaly 

    Let's say the data are in columns A and B, starting in row 2.

    Enter the following formula in a cell in row 2, for example in C2:

    =A2&B2

    Fill or copy down.

Resources