Issue:- During use Pivot in Microsoft Excel(above 2013 version), We are facing issue of auto date grouping. It means when make pivot and put Dates in “Rows” then all dates are grouped by yearly-Quaterly-Monthly by default. How to solve this issue and ungroup dates.
Root Cause:-Microsoft Excel feature upgradation
Solution:- Below are two methods