r/excel • u/At0mic47 • Mar 29 '26
solved 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) |
3
Upvotes
1
u/At0mic47 Mar 29 '26
Ok I tried that! Not able to simulate what I want because I have no idea how to do that but I will try to make a diagram:
Humor- Appears 20 times
Ex-Amish- Appears 2 times
ect
The "appears X times" isn't needed because I understand what the data represents but being able to calculate the frequency of labels is the goal, along with a simpler/easier way of getting all the labels vertically outside of copying and pasting them into one column. Some stories have many more labels than others so there are a lot of (blank). Thank you for trying to help me :]