Multiple scores on same scale

[#1]

Hi,

If I have data imported that has three columns: person, measure and score,  then there are a couple of ways I can make a graph that looks like the attached example (Method 1 (easiest): dimensions measure, then score or Method 2, just measure as a dimension and a count(if(score=1,1)) etc.

But if I have data imported that looks like:

Person sports_score,academics_score,social_score

is there a way to get exactly the same graph?

(I'm probably just being dim).

Thanks, Jon

Person	Measure	Score
Fred	sports	1
Mary	sports	3
June	sports	2
May	sports	4
Joe	sports	2
Fred	academics	4
Mary	academics	3
June	academics	3
May	academics	1
Joe	academics	2
Fred	Social	2
Mary	Social	2
June	Social	4
May	Social	4
Joe	Social	3

Person	sports	academics	social
Fred	1	4	2
Mary	3	3	2
June	2	3	4
May	4	1	4
Joe	2	2	3

[sunny_talwar · Accepted solution]

I would probably use CrossTable to convert the data so that it looks like the first data set. Read about CrossTable load here: The Crosstable Load