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 th...
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
