Forum Discussion
Chained Vlookups or Sumifs
I work with precipitation data from a station. the data is presented like this: in first column i have year-month like 1936-01 and in the quantity of rain in each day is presented in the correspondi...
Hi Mehdi,
The best way is to use Power Query (Aka Get & Transform Data in Excel 2016) to create a proper data set to be able to summarize it by using PivotTables tool which is the best tool to summarize data.
I've done this for you, please find the attached file to see it.
NOTE: if you don't have Excel 2016, you have to download and install the https://www.microsoft.com/en-us/download/details.aspx?id=39379.
Regards
Hi Haytham,
Pivoting could be done directly in query. e.g. as attached