Learn how to group data set real fast in Excel. <br /><br />Group Dataset Into Headers <br />1) Select cell D3 <br />2) =A2=A3 <br />3) Apply formula to the rest of the rows. <br />4) Select header <br />5) Ctrl + Shift + L <br />6) Filter column E by FALSE only <br />7) OK <br />8) Select all filtered row. <br />9) Alt + ; <br /> Select only visible cells within the current selection. <br />10) Right-click, Insert Row. <br />11) Ctrl + Shift + L <br />
