Learn how to group data set real fast in Excel.

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

#tip #excel #microsoft #shorts #short #shortvideo #shortsvideo #howto #how #google