i have to compare election results for same consituancy area for different elections held,which means i have to compare for each polling booth.i have my data in different sheets like this
vs name election pol. Booth no. poling booth detail BJP CPM BSP INC SHS JD (U) GGP BJSH RSMD GMS IND total
patan 95 vs 08 1 poudikala 295 4 12 105 8 1 8 5 2 3 26 469
patan 95 vs 08 2 poudikhurd 103 2 3 105 4 0 28 0 3 3 13 264
patan 95 vs 08 3 malakhurd 84 3 18 279 12 1 3 3 1 13 27 444
patan 95 vs 08 4 malakala 254 9 13 191 3 1 4 5 2 6 32 520
patan 95 vs 08 5 poudi hardua 169 2 28 418 10 2 4 3 4 14 37 691
this is one sample sheet,like this i have many sheets for different constituency as well as different elections .i want my comparison in this type of format
vs name election pol. Booth no. poling booth detail BJP CPM BSP INC SHS JD (U) GGP BJSH RSMD GMS IND total
patan 95 vs 08 1 poudikala











patan 95 vs 03 1 poudikala











bargi 96 vs 98 23 poudikala











patan 95 vs 08 4 poudikhurd











patan 95 vs 03 5 poudikhurd











bargi 96 vs 98 54 poudikhurd













so all the data relating one polling booth should fall in a single place for different years.i can not compare by matching columns as in each election polling booths shifts to a new constituency,so their order is different too.
i am using excel 2010 on windows 7.