Reorder rows content for each row

[siofont]

Hi there,
First of all, I'm sorry because I don't know if I can explain this in a understandable way (I don't know how to search for it). And maybe is not posible.

I'll have a file with electoral results with this structure (simplified):

Place 1 name | Voters | Blank votes | 1st party | votes for 1st party | %vote for 1st party | 2nd party | votes for 2nd party | %vote for 2nd party | 3rd party | votes for 3rd party | %vote for 3rd party | etc (8 parties in total)Place 2 name | Voters | Blank votes | 1st party | votes for 1st party | %vote for 1st party | 2nd party | votes for 2nd party | %vote for 2nd party | 3rd party | votes for 3rd party | %vote for 3rd party | etc (8 parties in total; around 1000 places)

Example with PartyA, PartyB, PartyC:

Place1 | 100 | 0 | PartyA | 50 | 50% | PartyC | 30 | 30% | PartyB | 20 | 20% | etc
Place2 | 100 | 0 | PartyC | 80 | 80% | PartyB | 20 | 20% | PartyA | 0 | 0% | etc

The problem is that parties are ordered in each row from most voted to less voted. So the order of parties change in each row according to the amount of votes.
The ideal output format for me is this, where each column has data for the same party:

Place 1 name | Voters | Blank votes | partyA | votes for partyA | %vote for partyA | partyB | votes for partyB | %vote for partyB | etc
Place 2 name | Voters | Blank votes | partyA | votes for partyA | %vote for partyA | partyB | votes for partyB | %vote for partyB | etc

After that, I'll do some calculations and comparisons with Excel.

Is this posible?
Thank you!

 

[tybaltlives]

very possible. here is how I did it using INDEX and MATCH. The purple highlighted cells need to be manually copied as a pair to the right for as many parties that you have. But once you get the first row completed you can copy that whole row downwards for as many places as you need. I put the raw data directly above the sorted data but you could rearrange them as needed to make room.

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Raw data
2	Place1	100	0	PartyA	50	50%	PartyC	30	30%	PartyB	20	20%	etc
3	Place2	100	0	PartyC	80	80%	PartyB	20	20%	PartyA	0	0%	etc
4
5
6				Votes	%	Votes	%	Votes	%
7	Place	Voters	Blanks	PartyA	PartyA	PartyB	PartyB	PartyC	PartyC
8	Place1	100	0	50	0.5	20	0.2	30	0.3
9	Place2	100	0	0	0	20	0.2	80	0.8
Sheet1

Cell Formulas
Range	Formula
A8	=A2
B8	=B2
C8	=C2
D8	=INDEX($A2:$M2,1,MATCH(D$7,$A2:$M2,0)+1)
E8	=INDEX($A2:$M2,1,MATCH(E$7,$A2:$M2,0)+2)

 

[siofont]

Thank you very much, tybaltlives
Very quick, precise and useful answer. Put in my Excel, it works perfectly.

 

[tybaltlives]

you are very welcome. happy to help. have a nice day.