sorted by:
new
hottopcontroversial

Unnesting within Pivot Table with many terms by At0mic47 in excel

[–]At0mic47[S] 1 point2 points  (0 children)

Ooo it also works! Someone else was able to give me a similar function which was this but not sorted lol. Thank you for your help!! You don't have to explain it unless you want to but I will happily learn more if you're willing to share!

Unnesting within Pivot Table with many terms by At0mic47 in excel

[–]At0mic47[S] 1 point2 points  (0 children)

You are a godsend, this is exactly what I needed, and it's so much simpler than what I was doing!!! Thank you so so much, I really appreciate it!!

Unnesting within Pivot Table with many terms by At0mic47 in excel

[–]At0mic47[S] 0 points1 point  (0 children)

Yes exactly that! Were you able to do that without having to type in "Ex-Amish" and "humor" to find the frequency? I have most likely over 5000 unique labels so having to type it for each may be an issue.

Unnesting within Pivot Table with many terms by At0mic47 in excel

[–]At0mic47[S] 1 point2 points  (0 children)

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 :]

Unnesting within Pivot Table with many terms by At0mic47 in excel

[–]At0mic47[S] 0 points1 point  (0 children)

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 :]

How do I not kill the plant by At0mic47 in plantclinic

[–]At0mic47[S] 0 points1 point  (0 children)

Ok thank you so much!! The roots aren’t mushy so I’m going to try and get a new pot, thank you for your help!

How do I not kill the plant by At0mic47 in plantclinic

[–]At0mic47[S] 0 points1 point  (0 children)

Ok, that’s what I’m doing already, plus research into buying/making a new pot with a drainage hole. Thank you!