Unstack data from one column to multiple columns - Excel Tips and Tricks - video Dailymotion

ExcelTips247

Learn how to unstack data from one column to multiple columns In Excel.  At the end of the video, you'll be able to answer all these questions.  - How do I unstack columns in Excel?  - How do I separate data from one column to multiple columns?  - How do I create unstacked data in Excel?  - Can you split the data stored in a column into multiple columns if yes how?  - How do I unstack text in Excel?  - How do I Uncombine two columns in Excel?   Unstack data from one column to multiple columns  1) Set cell C2 as =A2  2) Set cell D3 as =A3  3) Set cell E3 as =A4  4) Set cell F4 as =A5  5) Select newly assigned cells  6) Drag formula down to last row in raw table  7) Ctrl + G  8) Special  9) Blanks  10) OK  11) Right-click select cell  12) Delete...  13) Shift cells up  14) OK    Unstack data from one column to multiple columns,How do I unstack columns in Excel?,  How do I separate data from one column to multiple columns?,How do I create unstacked data in Excel?,Can you split the data stored in a column into multiple columns if yes how?,  How do I unstack text in Excel?,How do I Uncombine two columns in Excel?,   Check out my complete suite of Microsoft Excel Tips and Tricks.  https://www.youtube.com/@RabiGurungXybernetics/shorts  https://www.tiktok.com/@xybernetics247  https://www.instagram.com/rabi.gurung247/  https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/  https://twitter.com/XyberneticsInc/media  https://www.reddit.com/r/Excel247/  https://www.facebook.com/XyberneticsInc/reels/   #microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Transcript

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

Unstack data from one column to multiple columns - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended