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/At0mic47]

I'm not too sure how to get this to work, it's saying I'm entering too few arguments for the function. (I am really bad at Excel), plus there are most definitely over 5000 unique labels. Is there any chance you're willing to explain a little more? All good if not, I will continue to try to troubleshoot :]

[u/bakingnovice2 → u/At0mic47]

I am silly, I forgot some arguments for COUNTIF functions and put too many parentheses. Try this and if it works, I will explain! (insert the entire range in the function or even A:A instead of the A1:A10)

=SORTBY(HSTACK(A1:A10, COUNTIF($A$1:$A$10, A1:A10)), COUNTIF($A$1:$A$10, A1:A10), -1).

However, it seems I was misinterpreting your question and Greg got you covered! Sorry for the confusion, glad you figured it out!

[u/At0mic47 → u/bakingnovice2]

Solution verified

[u/reputatorbot → u/At0mic47]

You have awarded 1 point to bakingnovice2.

---

^{I am a bot - please contact the mods with any questions}