Many places across the UK have experienced their wettest January in more than 100 years.