Thread: Handling a vast matrix of numbers

I have five columns of data extending to 60,000 rows,
The first column indicates a high-order category, eg a State of the Union like NY
The second column indicates townships, e.g. NYC, Albany, Ithaca etc
The third column indicates municipalities eg Manhattan, Queens etc
The fourth and fifth columns contain raw data like name and number (the number of entries differs randomly for each municipality)

I am at a loss as to how to handle this best. Specifically, should try to transpose the 60,000 rows into making them columns? Should I create a Pivot Table, and if so how?

Any help or advice greatly appreciated

Incidentally, the data has to do with voting and elections, nothing confidential.

Thanks. Basically I what I want to do is use a "maximum" function to get a formula that declares the winning candidate for each municipality.

Thanks. These are the columns. It would be nice to add over Burroughs plus get a
function that gets a winner declared for each and overall too.

New York State
New York City
Bronx
1 Flyn 47062
2 Jones 45118
3 Stein 1251
4 Gonnzalez 1828
5 Shin 819

Brooklyn
1 Flyn 54317
2 Jones 42140
3 Stein 1175
4 Gonnzalez 1651
5 Shin 745

Manhattan
1 Flyn 38170
2 Jones 54648
3 Stein 7821
4 Gonnzalez 1917
5 Shin 939

Queens
1 Flyn 70879
2 Jones 32033
3 Stein 950
4 Gonnzalez 1718
5 Shin 670

Staten Island
1 Flyn 46313
2 Jones 49029
3 Stein 573
4 Gonnzalez 1303
5 Shin 440