Forum Discussion
Exil2212
Feb 07, 2024Copper Contributor
Remove duplicate rows, keep different columns
I am trying to combine information from multiple months and remove duplicate rows for information. The chart I have has thousands of rows, multiple duplicates, for 6 months. Is there a way to do it? ...
Patrick2788
Feb 07, 2024Silver Contributor
I'm hesistant to offer a formula solution as I suspect the larger data set might be more nuanced than the sample above. I will offer a simple PowerQuery solution.
- Exil2212Feb 07, 2024Copper ContributorThanks, that worked!
- Patrick2788Feb 07, 2024Silver ContributorGlad it worked! You're welcome.