00:00I recently demonstrated how you can split student name and test result from one column
00:04into two separate column and someone on the comment section has replied that why don't
00:08you just put 1212 next to the raw column and just filter it.
00:13Well, I'm here to demonstrate how you can do that.
00:15The first thing you have to do is to assign 1212 to the column just next to it.
00:21Just like this.
00:22I'm going to do that quickly here.
00:25Once you're done with it, place your cursor on the header cell, the first row itself,
00:29and press Ctrl Shift L to enable the filter.
00:32Now on this 1212 column that you just added, you're going to filter based on smallest to
00:37largest and you can see that the name and the test result get separated.
00:42Highlight the name, press Ctrl C and then put it right below the student column and press
00:46Ctrl V to paste it and for the test result do the same thing, Ctrl C and Ctrl V and you
00:52can actually get rid of this and Ctrl Shift L to remove the filter.
00:56All right.
Comments