Forum Discussion
Group data in pivot table
Hi everyone, I am trying to solve an issue creating a pivot tabel with these values - I have values by every second and my aim is to group them by minute and make an average. While trying to group the dates with time I get a "Cannot group that selection" error. From what I read I need to have my values formate as time/date and numbers, which I do (or it appears so). Would anyone be able to help please?
3 Replies
That's since datetime in the source is actually text which are to be converted to datetime. One of the ways - select column, Data->Text to Columns->split using space->on third step Date and YMD for the first column->select the column into which to copy. With result create one more column as Date+Time and copy/paste as value to initial time column. In PivotTable remove Time and add it again, refresh.
SergeiBaklan Great, it works perfectly! Thank you very much.
AnnaCer , you are welcome
