This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This is a tough one to answer without understanding what you are trying to do. I have a workflow attached that populates the second column based on the info in the first three rows and then sets the last equal to the first. Is this what you have in mind?
A join tool is equally good. When I have a small number of rows joining to a larger data set, I will tend to use Find-Replace. It has the added advantage of not sorting the data. In this case, it doesn't matter, but if the data was not sorted by the joining column and the sort order was important, then using join would require more work. By the way I noticed I had an inefficiency in my initial workflow -- I could have added both columns with the Find-Replace. I fixed that in the attached.