How to Combine Cells Together on Dashpivot Web

Prerequisites

Before you begin make sure you have the following:

Plan: All Plan Types
Permission: Home Folder (Template Library) – Org Controller (or higher); Team Folder – Project Controller (or higher)
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot

Open the template where you want to combine cell values.
Locate the cells you want to combine (for example, A1 and B1).
Add or edit a formula field where you want the combined result to appear.
Enter the formula =A1&B1 to combine the values directly.
To insert a space between the values, enter the formula =A1&" "&B1.
This way a name will read as 'John Smith', rather than 'JohnSmith'
Save the template to apply the changes.