You may use stacking option from any statistical software or R. If the data in txt format, you may directly open it with excel then use data option such as text in columns.
is your data in the form of year and monthly grid format?
if you want monthly rainfall data, you may go through the IITM, pune website. The website provides us most of the weather related data of all the subdivisions of the country . All the best.