Uploaded February 2025 | Updated September 2026, 12 hours ago
π₯ 400,000+ professionals trust our coursesβstart your journey here π link.xelplus.com/yt-d-all-courses
Finally solve the Rubik's Cube and actually remember the steps for next time. Whether itβs your first attempt or youβve tried before and given up, this method will get you to the finish line.
Full Rubik's cube video: youtu.be/0Ti5CKsQLts
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
πβ 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
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
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!
#rubikscube
π₯ 400,000+ professionals trust our coursesβstart your journey here π link.xelplus.com/yt-d-all-courses
Finally solve the Rubik's Cube and actually remember the steps for next time. Whether itβs your first attempt or youβve tried before and given up, this method will get you to the finish line.
Full Rubik's cube video: youtu.be/0Ti5CKsQLts
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
πβ 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
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
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!
#rubikscube


![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)







