Input collection: myContactNames17
FirstName | LastName | |
Johnson | Bruce | bjohnson@outlook.com |
Field | Sally | sfield@hotmail.com |
Nyugen | Sam | snyugen@hotmail.com |
Waters | Laura | lwaters@outlook.com |
Noble | Jackie | jnoble@outlook.com |
Output collection: mySolution17
FullName | |
Johnson, Bruce | bjohnson@outlook.com |
Field, Sally | sfield@hotmail.com |
Nyugen, Sam | snyugen@hotmail.com |
Waters, Laura | lwaters@outlook.com |
Noble, Jackie | jnoble@outlook.com |
Solution code:
//Create a collection
ClearCollect(myContactNames17,
{FirstName: "Bruce", LastName:"Johnson", Email: "bjohnson@outlook.com"},
{FirstName: "Sally", LastName: "Field", Email: "sfield@hotmail.com"},
{FirstName: "Sam", LastName: "Nyugen", Email: "snyugen@hotmail.com"},
{FirstName: "Laura", LastName: "Waters", Email: "lwaters@outlook.com"},
{FirstName: "Jackie", LastName: "Noble", Email: "jnoble@ooutlook.com"}
);
//Merge two columns code
ClearCollect(
mySolution17,
DropColumns(
AddColumns(
myContactNames17,
"FullName",
LastName&", "&FirstName
),
"FirstName","LastName"
)
);