How can i concatenate excel rows without using macro
For example :
I need to concate email column based on First name and Last name Columns
The output should be like this :
How to Concate excel rows without using macro ?
You should simply have to insert a NewLine from the String package. Using this as an example file:
I set up the following test steps:
- Excel (Advanced) Open
- Get single cell - C2 > output to variable $firstRow
- Get single cell - C3 > output to variable $secondRow
- String Assign - $firstRow$$String:NewLine$$secondRow$ to variable $lineOutput$
- Set cell - C10 $lineOutput$
The result:
While this isn’t exact to the process you are using, it should give you enough to go on to accomplish what you are after,
Userlevel 5
+14
Combine data with the Ampersand symbol (&)
-
Select the cell where you want to put the combined data.
-
Type = and select the first cell you want to combine.
-
Type & and use quotation marks with a space enclosed.
-
Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.
Combine data using the CONCAT function
-
Select the cell where you want to put the combined data.
-
Type =CONCAT(.
-
Select the cell you want to combine first.
Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
-
Close the formula with a parenthesis and press Enter. An example formula might be =CONCAT(A2, " Family").
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.