•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Made a pivot table to count unique values in a list of data - is there a way to combine unique values to count together in one row?
Our take
If you're working with a pivot table to count unique names but facing challenges due to variations in formatting, you're not alone. Many users encounter similar issues when names like "John Doe," "John D.," and "John" appear as separate entries. Fortunately, there are methods to consolidate these counts without needing to edit your original data. By using functions like CONCATENATE or employing custom formulas, you can effectively combine these variations into a single count in your pivot table, streamlining your analysis.
I have a list of names, and made a pivot table to count how often the names appear in the list. That I can do no problem.
However, some names are entered for formatted in different ways, for example John Doe vs John D. vs John -- will all count separately in different rows. Is there a way to maybe manually combine the rows into a single count? Without having to manually edit the data itself?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#rows.com#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Excel compatibility#Excel alternatives#row zero#pivot table#unique values#count#names