I have a data set that carries over from SAP that has duplicates in several different columns.
example below is how it pulls in and the desired outcome.
please advise the data set is huge and doing it manually is not an option
Book1 duplicates.xlsx
Bookmarks