I have a spreadsheet containing hundreds of row in the following format:
<tbody>
obs_code
obs_name
city
value_yr_1
value_yr_2
1104125
E and W
ABC
451
1104125
E and W
YZW
26
54
1104126
T and O
YZW
1
251
1104111
G and Y
ABC
54
1104111
G and Y
YZW
12
35
1104111
G and Y
TUS...