I have a spreadsheet to reformat in snaplogic. The rows contain either employee info or their dependent’s info. The employee row has an address but the dependent’s address fields are blank. I need to populate the dependent address columns with the matching employee record. Employee SSN is on both rows. I cannot figure out what snap to use to put that info into the columns. Anyone have an idea?
