How to rank items based on user input?

[rizzo93]

I need to create a list that shows the outcome of everybody's ranking of a list of items -- from most important to least important. Whatever item gets the most "votes" for being the most important will be the first in the list, the next item with the most votes gets the second, etc.

My users are ranking these items using Microsoft Forms and the data comes to me like this:

User 1: Gamma Ray Tron;Alpha Storm Purple;Beta Veal Orange;Omega Teal Staple;Delta Frank Ruby;
User 2: Gamma Ray Tron;Delta Frank Ruby;Beta Veal Orange;Omega Teal Staple;Alpha Storm Purple;
User 3: Gamma Ray Tron;Omega Teal Staple;Beta Veal Orange;Delta Frank Ruby;Alpha Storm Purple;
User 4: Gamma Ray Tron;Alpha Storm Purple;Omega Teal Staple;Delta Frank Ruby;Beta Veal Orange;
User 5: Alpha Storm Purple;Delta Frank Ruby;Gamma Ray Tron;Omega Teal Staple;Beta Veal Orange;

In the example above, the item that's furthest to the left is the highest priority, the one to the right of that is the second highest, and so on.

So User 1 wants Gamma Ray Tron to be the most important, then Alpha Storm Purple to be the second, and so on. Rinse and repeat for the other users.

My latest solution (which I think there has to be a better way) counts the number of times an item shows under each level of priority (1-5, in this case). If that number is the max, then it wins the vote ("W"):

	1	1W	2	2W	3	3W	4	4W	5	5W
Alpha Storm Purple	1		2	W	0		0		2	W
Beta Veal Orange	0		0		3	W	0		2	W
Delta Frank Ruby	0		2	W	0		2	W	1
Gamma Ray Tron	4	W	0		1		0		0
Omega Teal Staple	0		1		1		1		0

Is there better way and can it include automatically making a list the items in the proper order?