Uploaded March 2023 | Updated September 2026, 3 days ago
Join 300,000+ professionals in our courses: xelplus.com/courses
Microsoft Excel will now create a personalized toolbar just for you. It's based on your most frequently used commands for quick and easy access. And no worries, you'll still be able to view the classic ribbon whenever you want.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel #productivity
Join 300,000+ professionals in our courses: xelplus.com/courses
Microsoft Excel will now create a personalized toolbar just for you. It's based on your most frequently used commands for quick and easy access. And no worries, you'll still be able to view the classic ribbon whenever you want.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel #productivity










![The 1-Formula Fix for Excelβs Messiest Tables
Learn Python in Excel: https://www.xelplus.com/course/python-in-excel/
Sales data split across monthly columns? Heres how to reshape it into one clean table, with month, sales, and units each in their own column, using Python inside Excel.
=PY
pd.wide_to_long(sales_data, stubnames=[sales,units], i=sales rep, j=month, sep , suffix=.+).reset_index()
- Type =PY and press Tab to activate Python mode
- wide_to_long turns repeated column groups (like sales_Jan, units_Jan) into rows
- stubnames lists the values youre tracking
- i is your identifier column, like sales rep
- j names the new column that holds the month
- sep matches the separator in your source headers
- suffix=.+ means the leftover text can be anything
- reset_index() keeps everything aligned
- Right-click the Python output and choose Excel Value to drop it into cells
Add a new month to your source data and the table updates on its own.
Uses the pandas wide_to_long function. Check the pandas docs for the full reference.
π¨ Subscribe to Between the Sheets newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter
π Join this channel to get access to perks:
https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π² Letβs connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/in/leilagharani
#Excel The 1-Formula Fix for Excelβs Messiest Tables](https://i.ytimg.com/vi/aUlGfk7kst0/mqdefault.jpg)