Hello! I have had wonderful success in reaching out to the community for help in my new passion for this program so I was hoping to find a solution to this new problem that has left me stumped for a good two days.
I am trying to condense down 37 rows of data which contain a lot of 0's but some fields do have values. I would like to be able to group by every unique value in my data set then count how many times that value appears but because the data is so spread out I can't quite get there with how I have been trying now.
Any ideas would be fantastic thank you.
Sample data is attached
Solved! Go to Solution.
I would have done exactly what Kanderson has done. And as he says if you wanted to develop this further and understand the number of each value within each column then you would just add this in as a group by.
Amazing haha I never thought of flipping them into the a very long single row then grouping by value. Thank you so much for shedding light on this problem of mine. I am very happy to see its simple and I just didn't think of it in that manner