Forum Discussion
Merge of rows with identical names in some columns
I have a sheet with many dublicates in Column A. I if remove duplicates in that column the entire row is deleted. Is it possible to make a formula that "merges" the duplicates so there is only on Deb...
Monica2305 Perhaps you would like to try "Get & Transform Data" (a.k.a. Power Query) from the Data Ribbon. Transform your data to a structured table or named range and connect to it via "From Table/Range". The attached file contains an example. If you are not familiar with PQ, let me know.