MERGE Two Columns Into A Single Column


Input collection: myContactNames17

FirstNameLastNameEmail
JohnsonBrucebjohnson@outlook.com
FieldSallysfield@hotmail.com
NyugenSamsnyugen@hotmail.com
WatersLauralwaters@outlook.com
NobleJackiejnoble@outlook.com


Output collection: mySolution17

FullNameEmail
Johnson, Brucebjohnson@outlook.com
Field, Sallysfield@hotmail.com
Nyugen, Samsnyugen@hotmail.com
Waters, Lauralwaters@outlook.com
Noble, Jackiejnoble@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"
    )
);