Summation of every nth column
2 views (last 30 days)
I've imported xlsx file containing some data related to energy consumption, It was sampled in 15 minutes rate.
I want to convert this table to hourly values, in order to make hourly values I need to sum every 4 columns and store that data in a new matrix that sizes [8760x1], I want all the data be in series (just one column).
The data are for full year, so i expect to get 8760 (hours in a year) rows , and 1 column.
Thanks in advance.