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.
Apologies as I cannot quite figure out how to title this question.
I have a data set where I need to duplicate some of the rows and carry over only some of the data in the columns. In the picture below the top rows represents how the data is now. The bottom rows is how I would like the data to look after modifying it.
Also attaching the sample file if it helps.
I figured I might have to use some of the transform tools or the join tools, but haven't gotten the desired results.
Here's a little trick I use for cases like this: use a RecordID tool to assign a value to each row, convert that to a Double field, and add 0.5 to the records I want to stagger between. Check out the attached example to see this in action.