0
I have data in a excel spreadsheet in a regular pattern that needs to be organized in a format friendly to statistical analysis.
Here is the format:
Clinton 29.30% 22
Edwards 38.70% 29
Obama 32.00% 24
Adair
Clinton 36.00% 22
Edwards 38.00% 29
Obama 14.00% 24
Other 12.00% 10
Adams
I'd like it in a standard matrix format:
county candidate percent absolute
Adair clinton 29% 22
Adair obama 32% 24
...
Adams clinton 36%
Adams obama ....
What is the best way to do this in excel or google docs? Apologies if this is some kind of beginner question. I tried searching the forum, but couldn't find what this kind of procedure is called.
Is this an
Microsoft-Excel
question or aGoogle-Spreadsheet
question? The two platforms differ in the method to accomplish what you are looking for and it would be a waste of time to pursue one when you actually wanted the other. – Jeeped – 2014-12-01T04:03:19.093I'd be happy with a solution from either! i have access to both – tom – 2014-12-01T21:30:58.163
is there a better way to ask this question? should i only have asked for one? – tom – 2014-12-03T19:29:39.820