Y = reshape(nansum(reshape(X(:,2:7), [], 26, 6),2),[],6);
This will not have any date entries, but you did not define how you wanted that column handled. You could use
[X(1:26:end,1), Y]
if you wanted to select the first date of each group as indicating the time period.
