Spreadsheet: 682500d1592151124-how-to-pick-particular-year-data-given-in-different-columns-by-matching-unique-blocks-book1
Sheet: Sheet1

 | 2015
Unique Block | Year |  |  |  |  |  |  | Unique Block | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
B |  |  |  |  |  |  |  | A | 177110.6436 | 179069 | 197953.3031 | 200354.2039729765 | 197953.3031 | 200354.2039729765 | 246000.625
A |  |  |  |  |  |  |  | B | 360306.3132 | 364290 | 248295.3858 | 252034.7277446027 | 248295.3858 | 252034.7277446027 | 148183.5384
C |  |  |  |  |  |  |  | C | 93149.6004 | 94180 | 682180.1172 | 655606.1938571312 | 682180.1172 | 655606.1938571312 | 137880.9792
E |  |  |  |  |  |  |  | D | 117360.9504 | 118659 | 164702.1168 | 171827.5598208038 | 164702.1168 | 171827.5598208038 | 251729.7444
D |  |  |  |  |  |  |  | E | 57364.9452 | 57999 | 425056.14 | 443203.725492301 | 425056.14 | 443203.725492301 | 129001.4316
G |  |  |  |  |  |  |  | F | 279734.2992 | 282827 | 319846.2084 | 381127.4059226419 | 319846.2084 | 381127.4059226419 | 537657.6708
F |  |  |  |  |  |  |  | G | 78759.3816 | 79630 | 322359.7104 | 338656.0467682153 | 322359.7104 | 338656.0467682153 | 179961.1452
I |  |  |  |  |  |  |  | H | 266291.262 | 269236 | 119266.5096 | 122659.9757688993 | 119266.5096 | 122659.9757688993 | 258337.6236
J |  |  |  |  |  |  |  | I | 216399.6468 | 218792 | 99109.2312 | 48639.23519547663 | 99109.2312 | 48639.23519547663 | 308576.3148
H |  |  |  |  |  |  |  | J | 793686.7097194887 | 802463 | 210517.2684 | 207224.857174531 | 210517.2684 | 207224.857174531 | 176042.5452
L |  |  |  |  |  |  |  | K | 1189370.410494639 | 1202522 | 228062.055 | 250723.9496077056 | 228062.055 | 250723.9496077056 | 491250.2508
K |  |  |  |  |  |  |  | L | 1085476.752811845 | 1097479 | 257978.825 | 256677.9972472457 | 257978.825 | 256677.9972472457 | 266291.262
M |  |  |  |  |  |  |  | M | 1160036.076372237 | 1172863 | 117939.965 | 127619.6550019002 | 117939.965 | 127619.6550019002 | 216399.6468
N |  |  |  |  |  |  |  | N | 1094841.124196572 | 1106947 | 108110.99 | 103816.9586242338 | 108110.99 | 103816.9586242338 | 793686.7097194887
O |  |  |  |  |  |  |  | O | 930145.9264052177 | 940430 | 184662.075 | 174713.3069123422 | 184662.075 | 174713.3069123422 | 1189370.410494639
P |  |  |  |  |  |  |  | P | 271849.0493 | 276310.5315183255 | 246000.625 | 241827.1326065726 | 246000.625 | 241827.1326065726 | 1085476.752811845
R |  |  |  |  |  |  |  | Q | 158325.0107 | 159887.87988064 | 148183.5384 | 149822 | 148183.5384 | 149822 | 1160036.076372237
T |  |  |  |  |  |  |  | R | 93576.9418 | 94171.70244369081 | 137880.9792 | 139406 | 137880.9792 | 139406 | 1094841.124196572
S |  |  |  |  |  |  |  | S | 157520.5469 | 159068.3344960313 | 251729.7444 | 254513 | 251729.7444 | 254513 | 930145.9264052177
U |  |  |  |  |  |  |  | T | 121685.8534 | 122639.7663841467 | 129001.4316 | 130428 | 129001.4316 | 130428 | 271849.0493
W |  |  |  |  |  |  |  | U | 105268.7077 | 106001.4628828752 | 537657.6708 | 543603 | 537657.6708 | 543603 | 158325.0107
V |  |  |  |  |  |  |  | V | 112437.8998 | 113263.2968978673 | 179961.1452 | 181951 | 179961.1452 | 181951 | 93576.9418
Y |  |  |  |  |  |  |  | W | 149754.2038 | 151160.343821071 | 258337.6236 | 261194 | 258337.6236 | 261194 | 157520.5469
X |  |  |  |  |  |  |  | X | 68078.5941 | 68428.6917325229 | 308576.3148 | 311988 | 308576.3148 | 311988 | 121685.8534
Z |  |  |  |  |  |  |  | Y | 197953.3031 | 200354.2039729765 | 176042.5452 | 177989 | 176042.5452 | 177989 | 105268.7077
Q |  |  |  |  |  |  |  | Z | 248295.3858 | 252034.7277446027 | 491250.2508 | 496682 | 491250.2508 | 496682 | 112437.8998
AA |  |  |  |  |  |  |  | AA | 682180.1172 | 655606.1938571312 | 266291.262 | 269236 | 228062.055 | 250723.9496077056 | 149754.2038
AB |  |  |  |  |  |  |  | AB | 164702.1168 | 171827.5598208038 | 216399.6468 | 218792 | 257978.825 | 256677.9972472457 | 251729.7444
AC |  |  |  |  |  |  |  | AC | 425056.14 | 443203.725492301 | 793686.7097194887 | 802463 | 117939.965 | 127619.6550019002 | 129001.4316
AD |  |  |  |  |  |  |  | AD | 319846.2084 | 381127.4059226419 | 1189370.410494639 | 1202522 | 108110.99 | 103816.9586242338 | 537657.6708
AE |  |  |  |  |  |  |  | AE | 322359.7104 | 338656.0467682153 | 1085476.752811845 | 1097479 | 184662.075 | 174713.3069123422 | 179961.1452
AF |  |  |  |  |  |  |  | AF | 119266.5096 | 122659.9757688993 | 1160036.076372237 | 1172863 | 246000.625 | 241827.1326065726 | 258337.6236
AG |  |  |  |  |  |  |  | AG | 99109.2312 | 48639.23519547663 | 1094841.124196572 | 1106947 | 148183.5384 | 149822 | 308576.3148
AH |  |  |  |  |  |  |  | AH | 210517.2684 | 207224.857174531 | 930145.9264052177 | 940430 | 137880.9792 | 139406 | 176042.5452
AI |  |  |  |  |  |  |  | AI | 228062.055 | 250723.9496077056 | 271849.0493 | 276310.5315183255 | 251729.7444 | 254513 | 491250.2508
AJ |  |  |  |  |  |  |  | AJ | 257978.825 | 256677.9972472457 | 158325.0107 | 159887.87988064 | 129001.4316 | 130428 | 381127.4059226419
AK |  |  |  |  |  |  |  | AK | 117939.965 | 127619.6550019002 | 93576.9418 | 94171.70244369081 | 537657.6708 | 543603 | 338656.0467682153
AL |  |  |  |  |  |  |  | AL | 108110.99 | 103816.9586242338 | 157520.5469 | 159068.3344960313 | 179961.1452 | 181951 | 122659.9757688993
AM |  |  |  |  |  |  |  | AM | 184662.075 | 174713.3069123422 | 121685.8534 | 122639.7663841467 | 258337.6236 | 261194 | 48639.23519547663
AN |  |  |  |  |  |  |  | AN | 246000.625 | 241827.1326065726 | 105268.7077 | 106001.4628828752 | 308576.3148 | 311988 | 207224.857174531
AO |  |  |  |  |  |  |  | AO | 148183.5384 | 149822 | 112437.8998 | 113263.2968978673 | 176042.5452 | 177989 | 250723.9496077056
AP |  |  |  |  |  |  |  | AP | 137880.9792 | 139406 | 149754.2038 | 151160.343821071 | 491250.2508 | 496682 | 256677.9972472457
AQ |  |  |  |  |  |  |  | AQ | 251729.7444 | 254513 | 251729.7444 | 254513 | 93576.9418 | 94171.70244369081 | 127619.6550019002
AR |  |  |  |  |  |  |  | AR | 129001.4316 | 130428 | 129001.4316 | 130428 | 157520.5469 | 159068.3344960313 | 103816.9586242338
AS |  |  |  |  |  |  |  | AS | 537657.6708 | 543603 | 537657.6708 | 543603 | 121685.8534 | 122639.7663841467 | 99109.2312
AT |  |  |  |  |  |  |  | AT | 179961.1452 | 181951 | 179961.1452 | 181951 | 105268.7077 | 106001.4628828752 | 210517.2684
AU |  |  |  |  |  |  |  | AU | 258337.6236 | 261194 | 258337.6236 | 261194 | 112437.8998 | 113263.2968978673 | 228062.055
AV |  |  |  |  |  |  |  | AV | 308576.3148 | 311988 | 308576.3148 | 311988 | 149754.2038 | 151160.343821071 | 257978.825
AW |  |  |  |  |  |  |  | AW | 176042.5452 | 177989 | 176042.5452 | 177989 | 137880.9792 | 139406 | 137880.9792
AX |  |  |  |  |  |  |  | AX | 491250.2508 | 496682 | 491250.2508 | 496682 | 251729.7444 | 254513 | 251729.7444