Add a new column with a list of string value

[zoeuno]

Hopefully this is striaghtforward. As can be seen below, I have some data that I want to add a column of names to (all different), can someone tell me now to do that? Thanks!

Input
15	3
4	9
5	6
2	8
Output
AMY	15	3
BRIAN	4	9
CARL	5	6
DAVID	2	8

[NicoleJohnson]

Do you have the list of names in a separate output, i.e. two inputs that you'd like to join together?

Assuming this is the case and the first column of your top input is the joining field (field is contained in both inputs), you can use the Find & Replace tool to match them up (search for the common field in the top input and append the data from the name input when it finds a match), or a Join tool (join on the common field, and then select which fields to keep and the order you'd like them to display in the field list section in the bottom part of the Join tool configuration).

If that's not the right track, please provide a little more information about your particular requirements! Thanks!

Cheers,

NJ

[zoeuno]

Thank you for the reply! I don't have a separate input and just have the strings of names. For example "Amy Brian Carl David". Is there a way I can implement this without having to create a separate input sheet? Thanks!

[jdunkerley79]

You can store the names in a text input and use a Join by Record Position

Sample attached

[NicoleJohnson · Accepted solution]

Gotcha - see attached! Example of @jdunkerley79 solution, I believe... Copy your string of names to a text input, split text to rows using Text to Columns tool, and then join by record position.

Hope that helps!

NJ

[jdunkerley79]

Yep same solution but I listed downwards