Sheet two has column headers: job number, job category.
I need these two sheets to become one sheet. Sheet 1 and sheet 2 “job numbers” need to match up with the corresponding job category in the correct row.
I’ve attached three sample sheets but on the final merge sheet the yellow highlight does not need to be on it. I only wanted to point out what I need.
You can easily do this using a ‘join’ transform to join the 2 input spreadsheets using the ‘Job number’ columns as the key. For more details please see:
Is there any transform you would recommend for merging cells too?
I have database with many duplicate records/rows, but where some fields have been updated.
I.e.
Row1: Id1,Tom,Hansen,note1,status1
Row2: Id1,Tom,Hansen,note2,status1
Want a transform that gives:
Row1: Id1,Tom,Hansen,note1 note2,status1
The transform finds and merges duplicate rows, and where cells/fields are different it merges both, if cells/fields are same, it keeps only one/original.
I guess what I need is a cell check:
If data in duplicate 1: cell x is different than in duplicate 2: cell x, keep both.
and…
If data in duplicate 1:cell x is different than in duplicate 2: cell x, keep only data in duplicate 1:cell x.
(usually we will know which sheet/data has been updated the most recent = keep only this data, but sometimes we need both old and new)