Combine text from multiple columns into one

[datavis]

Hi Community,

I need to combine text from three different columns as shown below. The first table shows three columns that I need to combine. I need to add text and punctuate  so each row in the final column looks like this: Name - PO#1234 - End Date 10/22/2017 Also as shown in the small table below the first one in the example below.

Appreciate your help!

[Anonymous · Accepted solution]

Hey @datavis

A couple of options for you:

Column = Table[Name] & " - PO#" & Table[PO #] & " - End Date " & Table[End Date]

Or...

Column = 
COMBINEVALUES(
   " - PO#",
   COMBINEVALUES(" - End Date ", Table[Name], Table[PO #]),
   Table[End Date]
)

Hope this helps,

Parker

[datavis]

Works like a charm! Thank you Parker!