Advanced Insights - Report Builder - Combining multiple data into one column (concatenate)

Modified on Tue, 15 Jun, 2021 at 4:22 PM

Would you like to combine data from a number of columns into one?

For example, first name and last name, joined to make simply 'name'?

You can concatenate more than two columns to achieve this. Simply create a calculated field and add together each of the string columns, separated (or not) by a space as seen below:

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article