Group Dataset Real Fast In Excel - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

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

Transcript

00:00This is how you can split group of data in a Jiffy that looks like this.

00:04First, you're going to select any empty column. I'm going to select column D3 here and say equal

00:09A2 equal A3 and hit enter. Once that's done, double click on this handle to apply the formula

00:16to the rest of the rows. Next, select any of the cells on the header and press ctrl shift L

00:20to enable filter. Now you're going to filter the data set based on false only and click OK.

00:27Now select all the visible rows and press alternate semicolon to select only the visible cells here

00:34and after that, you're going to right click on this row here and hit insert row and then go back to your

00:40header and then press ctrl shift L to disable your filter. Now all you have to do is to apply the

00:46header like this and as a part of cleanup, you can actually get rid of this column here and all done.

Group Dataset Real Fast In Excel - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended