00:00I recently published a video on how to unstack raw data into two columns but
00:04someone had a question what if you have multiple line items or other multiple
00:08columns consider this data set here I got raw data in this column A and that
00:13name math science and English results all stack into one column itself but I
00:19want to move this into four different columns like this how do you do it well
00:23it's quite simple let me show you how it's done you go to cell C2 here which
00:27is the student name I'm gonna assign the very first record like that and then
00:31math you're gonna say equal this are math results and you go diagonally this way
00:35and in science this is the science results for this guy here and then for
00:40English results you're gonna select that like that so basically it's assigning it
00:45diagonally like that so next thing you're gonna do you're gonna select the cell
00:49like this for one record and you're gonna drag this cells all the way down to the
00:53very last row of your raw data like this and it should look something like that
00:58now you're gonna select the record that you just assign like this and you're
01:04gonna press ctrl G to open a go-to window like this in here you're gonna
01:09select special after that you're gonna select blanks and click OK this will
01:15select all the blank space that's in the selected cell area right click any of this
01:20select the cell here and you're gonna select delete from the delete this pop-up
01:25window come up now you're gonna select shift cell up like this and click on OK
01:29and you'll see that all the this stack data is actually split into each
01:34each individual column like this
Comments