I have thousand rows wihich contains duplicate rows with some unique data. I want merge duplicate rows so last column (location) all values remain. It is important the solution is simple and quick beacuse this kind of table is needed to do monthly.
More precisely what I need.xlsx
Please help!
Bookmarks