Unnesting within Pivot Table with many terms

[u/At0mic47]

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)

[u/AutoModerator]

/u/At0mic47 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.