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 Deborah, Brown but the two 1s in colunn C and E will both be in the "merged" row? Deborah, Provider, 1, Blanc, 1 would bebe the new line. I hope this makes sense. Best regards Monica
| Deborah Brown, APRN, RDMS | provider | 1 | ||
| Deborah Brown, APRN, RDMS | provider | 1 |
2 Replies
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.
Hi Monica2305
If you have a lots of rows, insert new sheet, place the curse on the first cell.
From Data tab --> in the Data Group choose consolidation
On the consolidation windows, choose sum in the function box, in the reference select your data, tick the Top row and Left column --> OK
* If my post helped you, please click on like.
