Help to transfer data

I do have about 20 excel files . Each file contains several stations with their longitude, latitiude, elevation , and rainfall depth for each month in 2015.

STATION NAME LATITUDE LONGITUDE ELEVATION DATE PRCP

 

US1TXBST017 WYLDWOOD 8.3 SSW, TX US 30.0287 -97.5496 178.9 2015-01 5.1
US1TXBST017 WYLDWOOD 8.3 SSW, TX US 30.0287 -97.5496 178.9 2015-02 0.8
US1TXBST017 WYLDWOOD 8.3 SSW, TX US 30.0287 -97.5496 178.9 2015-06 2.68
US1TXBST017 WYLDWOOD 8.3 SSW, TX US 30.0287 -97.5496 178.9 2015-09 0.54
US1TXBST017 WYLDWOOD 8.3 SSW, TX US 30.0287 -97.5496 178.9 2015-10 10.36
US1TXBST017 WYLDWOOD 8.3 SSW, TX US 30.0287 -97.5496 178.9 2015-11 3.04
US1TXBST017 WYLDWOOD 8.3 SSW, TX US 30.0287 -97.5496 178.9 2015-12 2.22
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-01 2.82
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-02 0.75
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-03 4.31
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-04 6.77
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-05 8.05
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-06 6.9
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-07 0
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-08 0.39
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-09 0.82
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-10 6.27
US1TXBXR134 MARION 6.3 SW, TX US 29.4921 -98.1911 196.9 2015-11 2.77

I need to summarize those rainfall data based on stations and month in a one sheet.

 

STATION NAME LATITUDE LONGITUDE ELEVATION 2015-01 2015-02 2015-03 2015-04 2015-05 2015-06 2015-07 2015-08 2015-09 2015-10 2015-11 2015-12
USC00412950 ESCOBAS, TX US 27.02667 -98.98083 125 4.29 1.68
USC00410498 BALMORHEA, TX US 30.9844 -103.7403 981.5 1.91 0 2.33 0.33 2.45 0.75 1.85 0.85 3.87 1.6 0.04
US1TXCML113 CANYON LAKE 1.5 WSW, TX US 29.8684 -98.2856 338 5.51 0.42 3.57 4.36 4.76 0.19 0.56 16.55 4.18 3.36
USC00418658 STOCKDALE 6 N, TX US 29.3258 -97.9752 161.5 0.14 7.31 6.61 8.73 3.5 0.17 1.36 0.5 2.72
US1TXTV0176 AUSTIN 2.4 N ALLANDALE, TX US 30.3402 -97.7488 203.3 4.75 0.8 4.89 2.09 5.36 1.12 0.87 2.41 3.35 1.96
US1TXHYS028 MANCHACA 2.1 ENE, TX US 30.1368 -97.8682 226.8 5.63 0.87 4.21 2.74 14.81 5.13 0.35 0.96 4.4 16.48 3.05 3.43
US1TXGP0017 MCQUEENEY 3.4 SW, TX US 29.5646 -98.0855 196 3 0 0 0 3 0 0 0 3 0
US1TXPR0019 WEATHERFORD 5.7 NNW, TX US 32.8273 -97.8204 343.2

 

Keep in mind that some stations do not have rainfall readings or are zeros.

 

By: Zaid

Leave a Reply

Your email address will not be published. Required fields are marked *