How do i make a list from this data?

Question

So i have the following table, how do i quickly make a list of the totals with their paired value, so take this:

and change it into this:

So that i can then sort the list by the total and find out which value has the most points, the actually table will have much more data.

Thank you, Kyle.

score 0 · Accepted Answer · answered Aug 10 '18 at 08:36

0

One way is try and select all the data you want to have to go from ´row to column´. Paste it where you want but select "Paste Special". Select the "Transpose" option and click "OK".

Also watch this video among others:

https://www.youtube.com/watch?v=uV4CvGR6w7E

answered Aug 10 '18 at 08:36

Simon Jensen

287
5
24

That's exactly what I needed, Thank you! – Kyle Mann Aug 10 '18 at 08:48

How do i make a list from this data?

1 Answers1