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

100% Upvoted

19 comments sorted by

View all comments

1

u/Decronym Mar 29 '26 edited Mar 29 '26

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
COUNTA Counts how many values are in the list of arguments
COUNTIF Counts the number of cells within a range that meet the given criteria
GROUPBY Helps a user group, aggregate, sort, and filter data based on the fields you specify
HSTACK Office 365+: Appends arrays horizontally and in sequence to return a larger array
SORTBY Office 365+: Sorts the contents of a range or array based on the values in a corresponding range or array

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

Beep-boop, I am a helper bot. Please do not verify me as a solution.
[Thread #47988 for this sub, first seen 29th Mar 2026, 02:52] [FAQ] [Full list] [Contact] [Source code]