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.
I have a data set that tracks how an account moves through the sales stages.
What I am trying to do is create a row for the first stage by duplicating the existing record and moving existing data from one field to the other and null the previous field. Attached are screenshots to better explain.
Here is my data after the rows have been duplicated.
For Record ID 1 and so on I need to:
take the created date value and move it to the Edit Date field then null the created date
take the old value field and move it to the new values field and null the old value
The issues is where, [generate row] = 0 I need to keep the second 0 for each opp-id the same and make the changes to just that first row for each opp-id.
So how can you help with this which is quite similar to what you have done even though different. I was finding solution when i came across you string. attached is the question and the data sheet.
Hi All, I have a data set with the first column as an identifier, i am trying to copy the first seven columns (B-H) in the data set if any entry exits from the columns I-ED when the identifier that is column A is the same. can someone help with this attached is the worksheet Thanks