Quick Excel Trick to Unstack Data from one Column to Multiple Columns
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
This trick is the easiest (or laziest) method to unstack data from one column to multiple columns. You might come across a case where you need to move data (or transpose data) from one column to multiple columns. If you Google this, you'll find different ways of doing this such as:
1. Using Excel array functions or the INDEX function
2. Power Query to unstack data
3. Excel macros for unstacking data
4. Excel add-ins that can unstack.
In this Excel tutorial, we'll take a look at the easiest method of unstacking data. The good thing with this method is that it's dynamic so if your source data change, the stacked version also updates automatically.
I also show you another quick trick at 3:18 - to hide the zeros out of view in Excel using custom number formatting.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/unstack-data-to-multiple-columns/
You'll find a similar trick used in these videos:
Transpose data: https://youtu.be/yYVokk0NdiI
Hack formula copy: https://youtu.be/zWhGVZ-R-6g
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео Quick Excel Trick to Unstack Data from one Column to Multiple Columns канала Leila Gharani
This trick is the easiest (or laziest) method to unstack data from one column to multiple columns. You might come across a case where you need to move data (or transpose data) from one column to multiple columns. If you Google this, you'll find different ways of doing this such as:
1. Using Excel array functions or the INDEX function
2. Power Query to unstack data
3. Excel macros for unstacking data
4. Excel add-ins that can unstack.
In this Excel tutorial, we'll take a look at the easiest method of unstacking data. The good thing with this method is that it's dynamic so if your source data change, the stacked version also updates automatically.
I also show you another quick trick at 3:18 - to hide the zeros out of view in Excel using custom number formatting.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/unstack-data-to-multiple-columns/
You'll find a similar trick used in these videos:
Transpose data: https://youtu.be/yYVokk0NdiI
Hack formula copy: https://youtu.be/zWhGVZ-R-6g
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео Quick Excel Trick to Unstack Data from one Column to Multiple Columns канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)Excel shortcut keys you SHOULD know!4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1Return Multiple Match Results in Excel (2 methods)Unstack Data In Excel With Power QueryTOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips includedEasiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)Discover the EASY way to Transform Text in Excel (No Formulas - just Power Query)Searchable Drop Down List in Excel (Very Easy with FILTER Function)Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank CellsMaster Excel's SUMPRODUCT FormulaQuickly Stack Excel Columns into One Long Column NO MACRO, NO FORMULA, NO COPY/PASTE.TOP 10 Outlook Tips EVERY Professional NEEDS To Know (in 2021)Optimized Excel Line Charts: Prevent drop to zero & dynamic Legend positioningExcel: Extract unique items for dynamic data validation drop down listExcel: How to Best Import External Data into Excel & Import data from the Web to ExcelConvert Columns to Rows in Excel (NO Transpose, NO Formulas - SIMPLY UNPIVOT in Power Query)Excel 3D Formulas Explained (Includes a Bonus Excel Hack!)Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel