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):
Example with PartyA, PartyB, PartyC:
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:
After that, I'll do some calculations and comparisons with Excel.
Is this posible?
Thank you!
Bookmarks