pivot table cannot group that selection

  • Thread starter Thread starter froggydetail
  • Start date Start date
F

froggydetail

I cannot get a column of data to group using a Pivot table. I have done
all the suggestions I've ever know to do in my data which are:

- i removed ALL blank entries
- i did the "text to columns" trick to convert all data to text, then
applied appropriate formatting for the data type.
- i copied all data and pasted special to ensure only the values were
entered.

none of this works and i don't know what else to try.
 
What's your data look like that should be grouped?

You said that you converted it to text? Did you mean that?

I think it has to be all numeric (including dates) to be able to be grouped.
 
Back
Top