Premium Only Content
![Quick Excel Trick to Unstack Data from one Column to Multiple Columns](https://1a-1791.com/video/s8/1/e/0/v/p/e0vpk.qR4e-small-Quick-Excel-Trick-to-Unstac.jpg)
Quick Excel Trick to Unstack Data from one Column to Multiple Columns
January 10, 2019 Excel Hacks: Tips & Tricks
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.
★ My Online Excel Courses ► https://courses.xelplus.com
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.
00:00 How To Unstack Column Data in Excel
00:41 Unstack Data from ONE Column to MULTIPLE Columns
03:18 Hide 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
✉ 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
-
2:14:30
FreshandFit
6 hours agoDavid Icke On COVID Lies, Censorship, Secret Societies, Infiltration of MAGA, AI Control, Alternative Media Subversion And MORE!
85.1K34 -
1:41:41
The Quartering
8 hours agoTrump's New IVF Order, GameStop CEO Denounces Wokeness Amid Sale, and Elon Musk's DOGE Role Revealed
92.3K55 -
LIVE
Dr Disrespect
7 hours ago🔴LIVE - DR DISRESPECT - TARKOV - ZERO TO HERO PISTOL ONLY
2,412 watching -
1:55:42
Film Threat
8 hours agoCRISIS ON MULTIPLE MARVEL MOVIES! | Hollywood on the Rocks
17.7K -
49:19
Miss Understood With Rachel Uchitel
1 day agoKris Krohn: The Real Estate Playbook for Financial Freedom
51.7K3 -
15:24
Bearing
9 hours ago"N*ZI GERMANY HAD TOO MUCH FREE SPEECH" - Brain Dead CBS Anchor Gets SCHOOLED 😂
13.7K30 -
23:18
Crowder Bits
10 hours agoDebunked: John Oliver's Outrageous Lies About Trump 2.0
122K51 -
1:59:18
Russell Brand
7 hours agoThe Battle for Truth: Gregg Hurwitz on Myth, Power & Cultural Control – SF540
158K71 -
2:00:46
Steven Crowder
10 hours agoFight! Major Lawsuit Announcement...
624K391 -
19:50
Clownfish TV
19 hours agoFacebook FIRED 'Underperforming' Employees and They're P*SSED!
36.8K14