HI, I have spreadsheet with address, floor number, expiration date. Many of the address match. I want to merge all the matching address into one row which keeping all the floor numbers and expiration dates for each address. Is that possible?
Thank you
If the addresses match exactly you can use the Unique transform to merge multiple rows for the same address into 1 row. You can choose what to do with other columns (e.g. concatenate them).
https://www.easydatatransform.com/help/1l/windows/html/unique.html