I have a set of values on an excel sheet. I tried to generate a Pivot table. The table generated does not preserve the order in which the values are displayed in the range. The Pivot Table automatically sorts the values. My requirement is to preserve the order of values. Is there a way out? Thanks in advance.