Hi all,
This is a bit of a tricky one. I'm attempting to wrangle my source data in to an xml format, and have in to this issue.
I have source data in two sheets. Both sheets have items that are linked by using a uniqueID. I would like to loop through the data in one sheet, find the last row for each unique ID, and then pull in the data from the other sheet with the same uniqueID and insert it immediately below the unique ID's from the first sheet. Loop and continue until all data has been paired/inserted on to the one sheet. On copying across new data I also need to copy down the preceeding row for some columns (in order to maintain the xml structure)
I've attached a sample sheet.
Sheet: XMLAttempt: Part 1 of the data
Sheet: SplitMethod: Needs to be paired with XMLAttempt data based on Column A UniqueID
Sheet: XMLAttempt_Result: This is what I hope the final result to look like. I have highlighted the data copied from SplitMethod as to where it should be inserted.
I know this is probably a little larger than the average help request. I'm sorry. A few snippets this forum has helped me work out in the past few weeks have really helped my skills along, but I'm not sure how to go about this one.
XMLAttempt Data
Merge1.JPG
SplitMethod Data
Merge2.JPG
Result
merge3.JPG
Bookmarks