•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Unnesting within Pivot Table with many terms
Hello! I am trying to make a “Spotify Wrapped” but for things I read online that have author-generated labels. I want to organize it by which label appears the most frequently but the only way I’ve found that possible with past (and less accurate) attempts is pivot tables. When I try it now, everything is nestled within itself and acts like an odd list. I’ve changed it to tabular form which is both helping and harming what I want to do.
I apologize if this doesn’t make much sense, I will happily explain more if asked! Thank you so much in advance :]
| pickling |
|---|
| canning |
| Ex-Amish |
| Ex-Amish Whitaker |
| Canning Tips No One Asked For |
| Humor |
| Mild Existential Crisis (About Pickles) |
| Amish Dennis Whitaker |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
| (blank) |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives
#pivot tables
#Spotify Wrapped
#author-generated labels
#tabular form
#pickling
#canning
#Ex-Amish
#Ex-Amish Whitaker
#Canning Tips
#Humor
#Mild Existential Crisis
#Amish Dennis Whitaker
#frequency